Bug #28163 Query Browser closes on indented queries
Submitted: 30 Apr 2007 13:39 Modified: 19 May 2009 12:50
Reporter: Diego Medina Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.11 OS:Linux (Fedora core 6)
Assigned to: CPU Architecture:Any

[30 Apr 2007 13:39] Diego Medina
Description:
when pasting this query in MySQL Query Browser, MQB closes. (The last two lines are indented,
[code]
select spidersony.spidersony_part_number as model_id from spidersonyitems
			join spidersony on spidersony.spidersony_id = spidersonyitem_model_id
			WHERE spidersonyitem_part_number like "w"

[/code]

The two tables can be empty and MQB still closes.

How to repeat:
Create this two tables

CREATE TABLE  `tools`.`spidersony` (
  `spidersony_id` int(11) NOT NULL auto_increment,
  `spidersony_url` varchar(255) NOT NULL default '',
  `spidersony_html` text NOT NULL,
  `spidersony_part_number` varchar(250) NOT NULL default '',
  `spidersony_description` varchar(250) NOT NULL default '',
  `spidersony_notes` text NOT NULL,
  `spidersony_price` double NOT NULL default '0',
  `spidersony_img_url` varchar(255) NOT NULL default '',
  `spidersony_type` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`spidersony_id`),
  KEY `spidersony_part_number` (`spidersony_part_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

and

CREATE TABLE  `tools`.`spidersonyitems` (
  `spidersonyitem_id` int(11) NOT NULL auto_increment,
  `spidersonyitem_part_number` varchar(200) NOT NULL default '',
  `spidersonyitem_description` varchar(250) NOT NULL default '',
  `spidersonyitem_notes` text NOT NULL,
  `spidersonyitem_img_url` varchar(250) NOT NULL default '',
  `spidersonyitem_price` float NOT NULL default '0',
  `spidersonyitem_model_id` int(11) NOT NULL default '0',
  `spidersonyitem_url` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`spidersonyitem_id`),
  KEY `spidersonyitem_model_id` (`spidersonyitem_model_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

don't enter any data, and then copy and paste this query

select spidersony.spidersony_part_number as model_id from spidersonyitems
			join spidersony on spidersony.spidersony_id = spidersonyitem_model_id
			WHERE spidersonyitem_part_number like  "w"

(The last two lines have 3 (TAB) to create the indentation.)
And MQB will close.
[30 Apr 2007 13:41] Diego Medina
If I start mysql-query from the shell, after it closes, I get this error.

Attachment: mysql-error.txt (text/plain), 4.03 KiB.

[30 Apr 2007 13:50] MySQL Verification Team
Thank you for the bug report. Verified as described.
[13 Dec 2007 5:29] Diego Medina
Any news on a fix?
[19 May 2009 12:50] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/