Bug #5598 Dragging table to query area creates illiegal alias name
Submitted: 15 Sep 2004 19:34 Modified: 1 Oct 2004 19:06
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.7-beta OS:Windows (Win XP / SP1)
Assigned to: Alfredo Kojima CPU Architecture:Any

[15 Sep 2004 19:34] Shuichi Tamagawa 
Description:
If you have tables like t1, t2 and build a query by drag & drop, it creates illegal alias name which consists only of digits.

How to repeat:
1.create 2 tables named t1 and t2.
2.drag t1 from 'Schemata' tab and drop it on the 'SELECT' button of pop-up tool
3.drag t2 from 'Schemata' tab and drop it on the 'Add Table(s)' button of pop-up tool
4.click 'Execute' button. -> Error 1064

Suggested fix:
Quote table and alias names with backtick, or make an option not to create alias name automatically.
[1 Oct 2004 19:06] Alfredo Kojima 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html
[28 Oct 2004 22:02] Shuichi Tamagawa 
This is not fixed in 1.0.8-beta yet.