Bug #26220 MySQL
Submitted: 9 Feb 2007 12:23 Modified: 13 Feb 2007 11:52
Reporter: Rohan Abraham Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.9 rc OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[9 Feb 2007 12:23] Rohan Abraham 
Description:
The query building by selecting the column names of tables from databases are not working. This worked fine on all earlier versions of MySQL Query browser that I have been using.

How to repeat:
Select a database (double click) and select a table (double click).

Now in the SQL Query are you will get the query like
SELECT * FROM contractor c;

Now select columns to the table
1) On selecting the contractor_id from the list
        SELECT `Contractor_ID` FROM contractor c;
2) On selecting the contractor_first_name
        SELECT c.`Contractor_First_Name` `Contractor_ID` FROM contractor c;

Please note that the , etc are not coming properly and c. etc are totally missing the column names. This worked perfectly on earlier versions of the MySQL Query Browser. Please check this out.

Suggested fix:
Each new column selected by clicking should be 
SELECT c.`Contractor_First_Name`, c.`Contractor_ID` FROM contractor c;
etc
[9 Feb 2007 12:39] Sveta Smirnova 
Thank you for the report.

Verified as described.
[13 Feb 2007 11:39] Yahoo Serious 
Duplicate of Bug #25943.
[13 Feb 2007 11:52] Sveta Smirnova 
Thank you for the note.

Marked as duplicate