MySQL Bugs: #5849: Double-clicking table name in Schemata list generates incorrect SQL syntax

Bug #5849	Double-clicking table name in Schemata list generates incorrect SQL syntax
Submitted:	1 Oct 2004 16:13	Modified:	1 Oct 2004 22:32
Reporter:	Gordon Mckeown	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.0.8 beta	OS:	Windows (Windows XP SP1)
Assigned to:		CPU Architecture:	Any

Description:
When double-clicking a table name in the Schemata list, a default query is generated ("SELECT * FROM table"), however an additional two characters are appended to the end: space and the first character of the table name.

So for a table name "master_table", the query is:

SELECT * FROM master table m

And for a table named "audit", the query is:

SELECT * FROM audit a

How to repeat:
Simple double-click a table name in the Schemata list.

OK, someone has explained to me that this is actually a valid syntax for table aliasing and as such is probably a feature! :)

Perhaps it would make sense to include the "as" statement to clarify that the additional character is there as an alias?

This has been bothering me for quite some time and I finally found this in the bug database. Whether or not is a valid sequence- it is confusing and unnecessary in this context. Please either add "AS" to this or take this "feature" out, or at least make it an option that can be turned off...