Skip to content

Loading…

DBAL-114: MsSqlPlatform - getListTablesSQL() get's sysdiagrams table #1082

Closed
doctrinebot opened this Issue · 5 comments

1 participant

@doctrinebot

Jira issue originally created by user bostjan:

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.

@doctrinebot

Comment created by bostjan:

One solution is to just add "AND name != 'sysdiagrams' " to sql statement

@doctrinebot

Comment created by @beberlei:

Assigned to Jouzas

@doctrinebot

Comment created by yaroslav:

Why it is not fixed yet? The solution is so easy. Please add to repository. Because on every release I should change it manually :(

@doctrinebot

Comment created by @beberlei:

Fixed

@doctrinebot

Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label
@doctrinebot doctrinebot added this to the 2.1.2 milestone
@doctrinebot doctrinebot closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.