Comment 12 for bug 1046882

Revision history for this message
Daniel Heimann (denu) wrote :

hi,

Oleksandr "Sanja" Byelkin's query from comment #9 gets broken too, when someone does...

SHOW FULL COLUMNS FROM `example`.`user`;

and "magically repaired" by executing...

SELECT a.* FROM example.user a WHERE ( EXISTS ( SELECT 1 FROM example.user b WHERE b.user = a.user LIMIT 1 ) );

While the query from comment #10 can not be executed at all:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT (EXISTS ( SELECT 1 FROM mysql.user b WHERE b.user = a.user LIMIT 1 ) )' at line 1