Bug #7378 Insert statement tries to change database
Submitted: 17 Dec 2004 9:11 Modified: 20 Jan 2005 7:30
Reporter: [ name withheld ] Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Windows (Windows2k)
Assigned to: CPU Architecture:Any

[17 Dec 2004 9:11] [ name withheld ]
When trying to insert the value 'House Agent' i get an error saying that I am trying to switch to database Agent , which of course doesn't exist.

I guess it is because the last three letters of the word House is use, but shouldn't the client pick up that the command is between apostrophe's and therefore not a command, but a value ?? 

Oh and btw. This happens in the query tool and the mysql client. 



How to repeat:
Insert into temp1 values('TownHouse Agent');

Suggested fix:
Change parser to ignore reserved words when they reside between apostrophe's
[17 Dec 2004 16:29] MySQL Verification Team

What version of MySQL server do you use?
[20 Dec 2004 7:30] [ name withheld ]
Sorry, I should've included that :) , I am running version 4.1
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".