| Bug #6654 | Can't use certain reserved words in quoted varchar queries. | ||
|---|---|---|---|
| Submitted: | 16 Nov 2004 3:58 | Modified: | 29 Nov 2004 10:44 |
| Reporter: | John Inman | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S2 (Serious) |
| Version: | 1.1.1 gama | OS: | Windows (Windows XP) |
| Assigned to: | Victor Vagin | CPU Architecture: | Any |
[29 Nov 2004 10:44]
Victor Vagin
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: When I try to do inserts via MySQL Query Browser (1.1.1g) and below.. I get an error when certain criteria is met. Typically, I have a table with a 'Notes' field. In this field I often make statements like "use caution.", or "next time use toaster instead." When I try to insert records with the reserved word 'use' inside my varchar field.. I get an error stating that MySQL can't change to the XXX schema. Example. DB: Jogging. Fields. idx - integer, auto, notnull, Date - datetime, JogTime - time, Notes - varchar(64) INSERT INTO Jogging VALUES(null, "2004-11-15", "00:07:15", "use caution .. dogs"); I get the error that MySQL can't change to the 'caution' schema. If I insert bogus information and then use MySQL QB to GUI edit the row.. I can make the change.. i.e. "use caution". However, it never seems to take when I use the QB-GUI INSERT statement. Good Luck. John. How to repeat: (doesn't) work(s) everytime (for me). Suggested fix: ?