Bug #25943 Multiple select fields with query building buttons generates incorrect query
Submitted: 30 Jan 2007 12:30 Modified: 2 Feb 2007 13:24
Reporter: Yahoo Serious (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.9 OS:Windows (Windows 2000 SP4)
Assigned to: Mike Lischke CPU Architecture:Any

[30 Jan 2007 12:30] Yahoo Serious 
Description:
When building a query with the "query building buttons" leads to an incorrect query.

How to repeat:
- start QB
- click query building button for SELECT
- click several columns, e.g. mysql.db.Show_view_priv, Alter_priv, Create_priv
>> Note incorrect query:
SELECT d., d., d.`Show_view_priv` `Alter_priv` `Create_priv` FROM mysql.db d;

Suggested fix:
Fix insertion-point
[30 Jan 2007 13:33] MySQL Verification Team 
Thank you for the bug report.
[2 Feb 2007 13:24] Mike Lischke 
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html
[13 Feb 2007 11:52] Sveta Smirnova 
Bug #26220 was marked as duplicate of this one
[13 Feb 2007 11:56] Sveta Smirnova 
Bug #26314 was marked as duplicate of this one