Bug #26735 Query browser rewrites SQL => result invalid

• Submitted: 28 Feb 2007 21:10
• Modified: 1 May 2007 14:40
• Reporter: Martin Friebe (Gold Quality Contributor) (OCA)
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.2.9rc
• OS: Windows (Windows XP)
• CPU Architecture: Any
• Tags: qc

[28 Feb 2007 21:10] Martin Friebe

Description:
Create the table as below, then open the query-browser and enter the Select:
SELECT '1234587890' FROM ino1;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c1 '1234587890' FROM ino1' at line 1

The query actually send to the server (via TCP/IP) is
SELECT , c1 '1234587890' FROM ino1;

How to repeat:
DROP TABLE IF EXISTS `test`.`ino1`;
CREATE TABLE  `test`.`ino1` (
  `c1` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 ROW_FORMAT=COMPRESSED;

insert into ino1 select null;
insert into ino1 select null;
insert into ino1 select null;
insert into ino1 select null;
insert into ino1 select null;

# in QB
SELECT '1234587890' FROM ino1;

Suggested fix:
-

[28 Feb 2007 23:07] MySQL Verification Team

Thank you for the bug report.

[27 Apr 2007 12:25] Michael G. Zinner

It's working here

Attachment: qb26735a.png (image/png, text), 57.69 KiB.

[27 Apr 2007 12:31] Mike Lischke

I cannot reproduce this problem with the current code. Please check in latest version.

[29 Apr 2007 13:07] Valeriy Kravchuk

Please, check with QB 1.2.11, and inform about the results.

[1 May 2007 14:40] Martin Friebe

Thanks,
I checked with 1.2.11 and the issue is no longer present.