Doctrine DBAL

Illegal quotes in SHOW FULL TABLES WHERE Table_type = "BASE TABLE"

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 2.0.2
  • Component/s: Platforms
  • Labels:
    None

Description

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()

Issue Links

is duplicated by

Bug - A problem which impairs or prevents the functions of the product. DDC-1019 Double quotation mark mysql query error on orm:convert-mapping --from-database

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Bernhard Schlas added a comment -

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

Show
Bernhard Schlas added a comment - Here is a temporary dirty patch for this problem. ONLY FOR TESTING PURPOSE!!!
Hide
Permalink
Karsten Dambekalns added a comment -

Why not simply change MySqlPlatform#getListTablesSQL()?

Show
Karsten Dambekalns added a comment - Why not simply change MySqlPlatform#getListTablesSQL()?
Hide
Permalink
Bernhard Schlas added a comment -

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

Show
Bernhard Schlas added a comment - Because did this quick and dirty patch before i read this issue. Actually i've attached a better one,
Hide
Permalink
Karsten Dambekalns added a comment -

With this change it works for me.

Show
Karsten Dambekalns added a comment - With this change it works for me.
Hide
Permalink
Benjamin Eberlei added a comment -

Fixed.

Show
Benjamin Eberlei added a comment - Fixed.

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Karsten Dambekalns
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: