bugs in autocompletion

User, date Message
Written by siMKin
5 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:

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 */
Written by ansgar
5 years ago
3950 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.