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
• Status: Not a Bug
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.0.7 beta
• OS: Windows (WinXP SP2)
• 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