bugs in autocompletion

User, date Message
Written by siMKin
6 years ago
Category: General
104 posts since Sun, 01 Apr 07
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:

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 */

Written by ansgar
6 years ago
4938 posts since Fri, 07 Apr 06
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.