MySQL Bugs: #16709: wrong quotes in SQL

Bug #16709	wrong quotes in SQL
Submitted:	22 Jan 2006 16:31	Modified:	23 Jan 2006 13:33
Reporter:	nikos dimitrakas	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.19	OS:	Windows (windows)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When I double click on a table I get a wrongly geneterated SQL SELECT statement. I have tables with names like proess, subject, user and when I double click on them the generated SQL places the table name within double quotes. This does not get accepted when I try to execute it. I get an SQL syntax error. Version 1.17 worked fine though. It used single apostophe ` to surround the table names instead of the double qoutes " that the version 1.19 uses.

How to repeat:
Quite obvious!

Suggested fix:
One can always remove the quotes completely or replace them with single apostrophes `

After installing a newer version of the mysql server (5.0.18) and the new mysql administrator (1.1.7), the query browser has swithed back to using the correct apostrophe in the SQL statements. The combination that didn't work well was with server version 5.0.16 and administrator version 1.1.5

Thank you for the bug report. According with your last comment
the bug is already fixed with latest server/QB and can be closed
as fixed on current version. Can you confirm?

Thanks in advance.

I guess so. Since the latest versions work fine, I guess this can be closed.

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Thank you for the feedback.