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
Benjamin Eberlei made changes -
Field Original Value New Value
Link This issue is duplicated by DDC-1019 [ DDC-1019 ]
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!!!
Bernhard Schlas made changes -
Attachment base_table.patch [ 10931 ]
Bernhard Schlas made changes -
Attachment base_table.patch [ 10931 ]
Bernhard Schlas made changes -
Attachment base_table.patch [ 10932 ]
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()?
Bernhard Schlas made changes -
Attachment base_table.patch [ 10932 ]
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,
Bernhard Schlas made changes -
Attachment base_table.patch [ 10933 ]
Bernhard Schlas made changes -
Attachment base_table.patch [ 10933 ]
Bernhard Schlas made changes -
Attachment base_table.patch [ 10934 ]
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.
Benjamin Eberlei made changes -
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.0.2 [ 10118 ]
Resolution Fixed [ 1 ]
Benjamin Eberlei made changes -
Workflow jira [ 12356 ] jira-feedback2 [ 17692 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 17692 ] jira-feedback3 [ 20047 ]
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-85, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

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

Dates

  • Created:
    Updated:
    Resolved: