Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-114

MsSqlPlatform - getListTablesSQL() get's sysdiagrams table

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.4
    • Fix Version/s: 2.1.2, 2.2
    • Component/s: Platforms
    • Labels:
      None
    • Environment:
      Windows 7, PHP 5.3.5, MSSQL 2008

      Description

      getListTablesSQL() function in MsSqlPlatform.php list all tables in database.

      If you have saved Database Diagrams it returns "sysdiagrams" table too.
      This table have field "name" with type "sysname" which have no mapping.

      If you run orm:validate-schema you get:
      [Doctrine\DBAL\DBALException]
      Unknown database type sysname requested, Doctrine\DBAL\Platforms\MsSqlPlatform may not support it.

      Best solution is that when getting tables to ignore "sysdiagrams" tables.

        Activity

        Bostjan Oblak created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Assignee Benjamin Eberlei [ beberlei ] Juozas Kaziukenas [ juokaz ]
        Benjamin Eberlei made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.1.2 [ 10160 ]
        Fix Version/s 2.2 [ 10142 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 12582 ] jira-feedback2 [ 17715 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17715 ] jira-feedback3 [ 20070 ]

          People

          • Assignee:
            Juozas Kaziukenas
            Reporter:
            Bostjan Oblak
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: