Bug #53140 SQL queries always fail with a syntax error
Submitted: 25 Apr 2010 12:02 Modified: 25 Apr 2010 16:01
Reporter: Yves Goergen Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.19 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[25 Apr 2010 12:02] Yves Goergen
I created a connection to a local MySQL 5.0.67-nt server with the ANSI quotes option. Then I tried to run some SQL queries that work just fine in my application, like this:

select m."MessageId" from "message" m;

but they all fail with a syntax error around the double-quotes or unknown table names. The error messages are all plain wrong. The SQL query feature is unusable like this. Is it a known beta bug? The download page says that Workbench is replacing Squery Editor only from 5.2 onwards, but GA is only at 5.1. Query Editor is of course no longer available so there is currently no official alternative from MySQL. I think I'll need to head over to third-party software until MySQL gets their product portfolio sorted out.

How to repeat:
[25 Apr 2010 13:45] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Please run query "SELECT @@sql_mode" in MySQQL Workbench and send us result.
[25 Apr 2010 15:46] Yves Goergen
The result of the query is empty (one row, one column, no content).
[25 Apr 2010 15:50] Sveta Smirnova
Thank you for the feedback.

This means no SQL_MODE ansi set, so it is correct what query fails. This is not MySQL Workbench bug.
[25 Apr 2010 16:01] Yves Goergen
Hey, but what is the ANSI quotes option in the connection dialogue good for then?