Bug #6463 use at end of fieldname is interpreted as keyword
Submitted: 5 Nov 2004 14:52 Modified: 12 Nov 2004 3:27
Reporter: Thomas Baumgartner Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLGUI Severity:S3 (Non-critical)
Version:1.1.0 gamma OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[5 Nov 2004 14:52] Thomas Baumgartner 
Description:
When a fieldname ends with 'use', this 'use' is interpreted as keyword for changing the data base.
Two examples:

SELECT D.xxxxuse FROM Database.Table D;
==> Error message: The default scheme cannot be changed to FROM

SELECT D.xxxxuse AS yyyy FROM Database.Table D;
==> Error message: The default scheme cannot be changed to AS

How to repeat:
Create a table with at least one field whos name ends with a field named 'xxxxuse' and invoke the command:
SELECT D.xxxxuse FROM Database.Table D;

Suggested fix:
The keyword USE for switching the scheme has to be leaded by \newline or space.
[12 Nov 2004 3:27] MySQL Verification Team 
Thank you for your interest in the MySQL graphical administration
tools.
We recommend that you use our MySQL Administrator and MySQL Query
Browser.  The MySQLGUI and MySQL Command Center legacy products are
deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/