MySQL Bugs: #63940: MySQL Workbench

Bug #63940	MySQL Workbench
Submitted:	5 Jan 2012 16:21	Modified:	3 Feb 2012 3:54
Reporter:	maison sakamoto	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S1 (Critical)
Version:	5.2.37	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
sql exemple not run, and close the aplication:

select c.* from tab_carta c where cart_id=38;

How to repeat:
sql exemple not run, and close the aplication:

select c.* from tab_carta c where cart_id=38;

Please, send the output of Help > System Info menu item. Send also the results of:

show create table  tab_carta\G

SQL syntax error near 'insyert into rel_prop_veic(prop_id) values(24)'
SQL syntax error near 'insert into rel_prop_veic(prop_id) values(24)'
SQL syntax error near 'c.cart_id,
    (select prop_nome from tab_proprietario where prop_id= c.cart_pr'
MySQL Workbench CE for Windows version 5.2.37  revision 8576
Configuration Directory: C:\Users\Btr\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 3.3.0
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 32-bit
CPU: 4x Intel(R) Core(TM) i3-2120 CPU @ 3.30GHz, 3.0 GiB RAM
Active video adapter (0): NVIDIA GeForce 8400 GS
Installed video RAM: 512 MB
Current video mode: 1600 x 900 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.8562
Installed display drivers: nvd3dum.dll,nvwgf2um.dll,nvwgf2um.dll
Current user language: Português (Brasil)

command show create table  tab_carta\G result in error.

command executed: command show create table  tab_carta
'CREATE TABLE `tab_carta` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT,
  `veic_id` int(11) NOT NULL,
  `cart_prop_prop` int(11) DEFAULT NULL COMMENT ''proprietario tab_proprietario'',
  `cart_prop_est` int(11) DEFAULT NULL COMMENT ''proprietario tab_estrangeiro'',
  `cart_tipo_prop` varchar(10) NOT NULL COMMENT ''tipo: fisico\ntipo: juridico\ntipo: estrangeiro'',
  `cart_mot_mot` int(11) DEFAULT NULL COMMENT ''motorista tab_motorista'',
  `cart_mot_est` int(11) DEFAULT NULL COMMENT ''motorista tab_estrangeiro'',
  `cart_emissao` date NOT NULL,
  `cart_valor` double DEFAULT NULL,
  `cart_adiantamento` double DEFAULT NULL,
  `cart_inss` double DEFAULT NULL,
  `cart_sest` double DEFAULT NULL,
  `cart_senat` double DEFAULT NULL,
  `cart_liquido` double DEFAULT NULL,
  `cart_manifesto` varchar(25) DEFAULT NULL,
  `cart_imposto_renda` double DEFAULT NULL,
  `cart_origem` varchar(30) DEFAULT NULL,
  `cart_destino` varchar(30) DEFAULT NULL,
  `cart_peso_contratado` int(11) DEFAULT NULL,
  `cart_peso` int(11) DEFAULT NULL,
  `cart_filial` varchar(20) DEFAULT NULL,
  `cart_data_pagamento` date DEFAULT NULL,
  `cart_tipo_pagamento` varchar(30) DEFAULT NULL,
  `cart_descricao` longtext,
  PRIMARY KEY (`cart_id`),
  KEY `fk_mot_est` (`cart_mot_est`),
  KEY `fk_mot_mot` (`cart_mot_mot`),
  KEY `fk_prop_est` (`cart_prop_est`),
  KEY `fk_prop_prop` (`cart_prop_prop`),
  KEY `fk_veic_id` (`veic_id`),
  CONSTRAINT `fk_mot_est` FOREIGN KEY (`cart_mot_est`) REFERENCES `tab_estrangeiro` (`est_id`),
  CONSTRAINT `fk_mot_mot` FOREIGN KEY (`cart_mot_mot`) REFERENCES `tab_motorista` (`mot_id`),
  CONSTRAINT `fk_prop_est` FOREIGN KEY (`cart_prop_est`) REFERENCES `tab_estrangeiro` (`est_id`),
  CONSTRAINT `fk_prop_prop` FOREIGN KEY (`cart_prop_prop`) REFERENCES `tab_proprietario` (`prop_id`),
  CONSTRAINT `fk_veic_id` FOREIGN KEY (`veic_id`) REFERENCES `tab_veiculo` (`veic_id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1'

thanks for your atention!

Thanks a lot for your report Maison.
Reproduced:
Windows XPx86
WB 5.2.37
Sakila DB query:
select c.* from actor c where actor_id=38;
Thanks.

Fixed as of 5.2.38:

A query similar to the following would crash Workbench:
"select c.* from actor c where actor_id=38"