| Bug #24852 | Mysql Keywords seems not to be recognized | ||
|---|---|---|---|
| Submitted: | 6 Dec 2006 14:03 | Modified: | 14 Jan 2009 16:48 |
| Reporter: | Sébastien BAUDRU | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S4 (Feature request) |
| Version: | OS: | Any | |
| Assigned to: | CPU Architecture: | Any | |
[14 Jan 2009 16:48]
Susanne Ebrecht
Many thanks for writing a feature request. Unfortuntaly, how you escape identifiers is depending on the sql mode that you are using. So we won't fix this because it is unclear if the user uses ansi sql mode where reserved keywords should have been set into """ or if he is using mysql sql mode where backticks are used.
Description: I'm using the drag-and-drop feature of Mysql Query Browser, I encounter some problems : the SQL Query Editor doesn't put "`" around my column name, and since this column is named like a MySQL keyword, my query return a problem. How to repeat: Here is the constraints : - My Column name is named with a mysql keywords ('lock') - I drag-and-drop the component to the query editor, but this last one doesn't recognize the keywords and forgot to put some "`" before and after my column-name. Suggested fix: Always put "`" around the column name, even if it's not a MySQL keyword ?