DBAL-85: Illegal quotes in SHOW FULL TABLES WHERE Table_type = "BASE TABLE" #2086

Closed
doctrinebot opened this Issue Feb 4, 2011 · 8 comments

2 participants

@doctrinebot

Jira issue originally created by user k-fish:

When trying to generate update SQL on MySQL running in ANSI SQL mode you get the error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'BASE TABLE' in 'where clause'

This is caused by the use of identifier quotes (") instead of literal quotes (') in the query
SHOW FULL TABLES WHERE Table_type = "BASE TABLE"

This is in MySqlPlatform#getListTablesSQL()

@doctrinebot

Comment created by rroor:

Here is a temporary dirty patch for this problem. ONLY FOR TESTING PURPOSE!!!

@doctrinebot

Comment created by k-fish:

Why not simply change MySqlPlatform#getListTablesSQL()?

@doctrinebot

Comment created by rroor:

Because did this quick and dirty patch before i read this issue. Actually i've attached a better one,

@doctrinebot

Comment created by k-fish:

With this change it works for me.

@doctrinebot

Comment created by @beberlei:

Fixed.

@doctrinebot

Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label Dec 7, 2015
@beberlei beberlei was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot added this to the 2.0.2 milestone Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment