bugs in autocompletion

[expired user #1821]'s profile image [expired user #1821] posted 17 years ago in General Permalink
I've noticed the table-column completion still contains a few bugs. Before posting a bug report on the sourceforge website i thought i'd better start a topic where i - and others - can collect all the bugs first.

Two come to mind at this moment:

SELECT 
FROM (table1 AS one, table2 AS two)
LEFT JOIN table3 AS three ON one.
/* SQL Error: Table 'test.(table1' doesn't exist */


cursor is right after WHERE two.
SELECT one.id, (SELECT COUNT(*) FROM table2 AS two WHERE two.)
FROM table1 AS one
/* SQL Error: Table 'test.two' doesn't exist */
ansgar's profile image ansgar posted 17 years ago Permalink
Both confirmed. Fixed in rev 1396 for these and a variety of other cases where the table is preceeded by a comma for example:
SELECT * FROM (table1 AS one,table2 AS two) WHERE one.[!!!] OR two.[!!!]


Also both tablenames and/or aliases now may be quoted by backticks:
SELECT * FROM `table1` AS one WHERE table1.[!!!] OR one.[!!!]

Please login to leave a reply, or register at first.