Bug #5642 First letter of table name copied to query box after Select..
Submitted: 18 Sep 2004 11:49 Modified: 20 Sep 2004 17:48
Reporter: d b Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.0.7 beta OS:Windows (WinXP SP2)
Assigned to: CPU Architecture:Any

[18 Sep 2004 11:49] d b
Description:
When table name is double clicked in schemata list, Select query is written to query box followed by the first letter of table name.
Example#1:
Table name = gl_tbl:
1) Dbl-click gl_tbl in schemata list.
Resulting Query sent to Query box = SELECT * FROM gl_tbl g

Example#2
Table name = job_post_tbl:
1) Dbl-click job_post_tbl in schemata list.
Resulting Query sent to Query box = SELECT * FROM job_post_tbl j

How to repeat:
Open  MySQl Query Browser.
Select Schemata.
Double-Click table to begin SELECT Query.

First letter of table name follows Select Query.
[20 Sep 2004 17:48] Michael G. Zinner
This is not a bug. An table alias is added on purpose. Because when you do a join, we need the alias to correctly identify a table.

Example:

SELECT * FROM joinmaster m, joindetail d
WHERE d.idjoinmaster=m.idjoinmaster