MySQL Bugs: #6463: use at end of fieldname is interpreted as keyword

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
Category:	MySQLGUI	Severity:	S3 (Non-critical)
Version:	1.1.0 gamma	OS:	Microsoft Windows (Windows 2000)
Assigned to:		Target Version:

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.

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/