MySQL Bugs: #23626: Linux QB 1.2.4rc builds invalid SQL statement when selecting columns

Bug #23626	Linux QB 1.2.4rc builds invalid SQL statement when selecting columns
Submitted:	25 Oct 2006 13:35	Modified:	18 Aug 2007 3:31
Reporter:	C L	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4beta	OS:	Linux (Fedora Core 5)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
In the 1.2.4beta version of Query Browser, the FC5 version installed in package:
mysql-query-browser-5.0r4-1fc5

When selecting a column from the schemata window a query is automatically created.  The Windows version of 1.2.4beta creates the following SQL statement.

SELECT i.name FROM item i;

The Linux version creates the following statement:

SELECT * FROM item i, i.name;

The Linux version generates an unusable SQL statement.  Repositioning the cursor to the correct location in the statement does not fix the problem.  And columns selected from the schemata window are always placed at the end of the line.  The windows version builds the statement correctly.

How to repeat:
Repeatable follow the steps in the description.

Thank you for the bug report. Verified on Suse 10.1.

Hi,

How exactly do you do the selection - by double clicking on tree node or by dragging the node into query area, etc? Is this problem similar to #24672? If yes, then it was fixed and will be available in the next release. Dragging works for me as well.

>How exactly do you do the selection - by double clicking on tree node or by dragging the node into query area, etc? 

Double clicking on the tree node.

>Is this problem similar to #24672? If yes, then it was fixed and will be available in the next release. Dragging works for me as well.

The problem was similar in that the clicking method did not product the correct SQL statement.  But the symptoms were clearly different between 1.2.4 and 1.2.5.  1.2.4 created a SQL statement, clearly wrong.  1.2.5 did not create a statement at all.

Looking forward to the next release.

The same exists in Version 1.2.9rc for Windows XP.

After select columns from the schema tree. Click or Drag & Drop results in the same error.

Sample after two clicks:

SELECT a., a.`mandatory` `name` FROM product_attributes p, attributes a
WHERE p.attribute_id=a.attribute_id;

It seems there is a problem with the cursor position.

I wasn't able to repeat anymore with version 1.2.12.