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: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S1 (Critical) |
Version: | 5.2.37 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[5 Jan 2012 16:21]
maison sakamoto
[8 Jan 2012 17:10]
Valeriy Kravchuk
Please, send the output of Help > System Info menu item. Send also the results of: show create table tab_carta\G
[9 Jan 2012 11:26]
maison sakamoto
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!
[11 Jan 2012 18:58]
Armando Lopez Valencia
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.
[3 Feb 2012 3:54]
Philip Olson
Fixed as of 5.2.38: A query similar to the following would crash Workbench: "select c.* from actor c where actor_id=38"