MySQL Bugs: #53140: SQL queries always fail with a syntax error

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:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.19	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
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:
1.
2.
3.

Thank you for the report.

I can not repeat described behavior. Please run query "SELECT @@sql_mode" in MySQQL Workbench and send us result.

The result of the query is empty (one row, one column, no content).

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.

Hey, but what is the ANSI quotes option in the connection dialogue good for then?