Bug #61904 show columns caused crash

• Submitted: 19 Jul 2011 3:05
• Modified: 24 Sep 2011 17:06
• Reporter: Dann Corbit
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.34
• OS: Windows (Server 2008 R2)
• CPU Architecture: Any

[19 Jul 2011 3:05] Dann Corbit

Description:
show columns crashed the workbench.  There are 103 tables, most are very simple single column tables.

This is the list of tables (every table with a name starting with test_ has a single column of the obvious data type):
SHOW CREATE TABLE  `test`.`bike`;
SHOW CREATE TABLE  `test`.`blobtest`;
SHOW CREATE TABLE  `test`.`books`;
SHOW CREATE TABLE  `test`.`catalog`;
SHOW CREATE TABLE  `test`.`customer_signed`;
SHOW CREATE TABLE  `test`.`customer_unsigned`;
SHOW CREATE TABLE  `test`.`dcorbit64_dbo_varcharmaxtest_acd`;
SHOW CREATE TABLE  `test`.`employee`;
SHOW CREATE TABLE  `test`.`inventory`;
SHOW CREATE TABLE  `test`.`orders`;
SHOW CREATE TABLE  `test`.`orders2`;
SHOW CREATE TABLE  `test`.`orders3`;
SHOW CREATE TABLE  `test`.`orders4`;
SHOW CREATE TABLE  `test`.`product`;
SHOW CREATE TABLE  `test`.`product2`;
SHOW CREATE TABLE  `test`.`serial_test`;
SHOW CREATE TABLE  `test`.`serial_test_2`;
SHOW CREATE TABLE  `test`.`shelf`;
SHOW CREATE TABLE  `test`.`tablesynchronizations`;
SHOW CREATE TABLE  `test`.`test_bigint`;
SHOW CREATE TABLE  `test`.`test_binary1`;
SHOW CREATE TABLE  `test`.`test_binary2`;
SHOW CREATE TABLE  `test`.`test_binary3`;
SHOW CREATE TABLE  `test`.`test_binary4`;
SHOW CREATE TABLE  `test`.`test_binary5`;
SHOW CREATE TABLE  `test`.`test_binary6`;
SHOW CREATE TABLE  `test`.`test_binary7`;
SHOW CREATE TABLE  `test`.`test_binary8`;
SHOW CREATE TABLE  `test`.`test_binary9`;
SHOW CREATE TABLE  `test`.`test_bit1`;
SHOW CREATE TABLE  `test`.`test_bit2`;
SHOW CREATE TABLE  `test`.`test_bit3`;
SHOW CREATE TABLE  `test`.`test_bit4`;
SHOW CREATE TABLE  `test`.`test_bit5`;
SHOW CREATE TABLE  `test`.`test_bit6`;
SHOW CREATE TABLE  `test`.`test_bit7`;
SHOW CREATE TABLE  `test`.`test_bit8`;
SHOW CREATE TABLE  `test`.`test_bit9`;
SHOW CREATE TABLE  `test`.`test_blob`;
SHOW CREATE TABLE  `test`.`test_bool1`;
SHOW CREATE TABLE  `test`.`test_char1`;
SHOW CREATE TABLE  `test`.`test_char255`;
SHOW CREATE TABLE  `test`.`test_date`;
SHOW CREATE TABLE  `test`.`test_datetime`;
SHOW CREATE TABLE  `test`.`test_decimal`;
SHOW CREATE TABLE  `test`.`test_double`;
SHOW CREATE TABLE  `test`.`test_float4`;
SHOW CREATE TABLE  `test`.`test_float8`;
SHOW CREATE TABLE  `test`.`test_geometry`;
SHOW CREATE TABLE  `test`.`test_geometrycollection`;
SHOW CREATE TABLE  `test`.`test_int`;
SHOW CREATE TABLE  `test`.`test_int1`;
SHOW CREATE TABLE  `test`.`test_int1u`;
SHOW CREATE TABLE  `test`.`test_int2`;
SHOW CREATE TABLE  `test`.`test_int2u`;
SHOW CREATE TABLE  `test`.`test_int3`;
SHOW CREATE TABLE  `test`.`test_int3u`;
SHOW CREATE TABLE  `test`.`test_int4`;
SHOW CREATE TABLE  `test`.`test_int4u`;
SHOW CREATE TABLE  `test`.`test_int8`;
SHOW CREATE TABLE  `test`.`test_int8u`;
SHOW CREATE TABLE  `test`.`test_int_unsigned`;
SHOW CREATE TABLE  `test`.`test_lb`;
SHOW CREATE TABLE  `test`.`test_linestring`;
SHOW CREATE TABLE  `test`.`test_longblob`;
SHOW CREATE TABLE  `test`.`test_longtext`;
SHOW CREATE TABLE  `test`.`test_lt`;
SHOW CREATE TABLE  `test`.`test_lvb`;
SHOW CREATE TABLE  `test`.`test_lvc`;
SHOW CREATE TABLE  `test`.`test_mediumblob`;
SHOW CREATE TABLE  `test`.`test_mediumint`;
SHOW CREATE TABLE  `test`.`test_mediumtext`;
SHOW CREATE TABLE  `test`.`test_middleint`;
SHOW CREATE TABLE  `test`.`test_multilinestring`;
SHOW CREATE TABLE  `test`.`test_multipoint`;
SHOW CREATE TABLE  `test`.`test_multipolygon`;
SHOW CREATE TABLE  `test`.`test_nationalchar1`;
SHOW CREATE TABLE  `test`.`test_nationalchar255`;
SHOW CREATE TABLE  `test`.`test_numeric`;
SHOW CREATE TABLE  `test`.`test_point`;
SHOW CREATE TABLE  `test`.`test_polygon`;
SHOW CREATE TABLE  `test`.`test_real`;
SHOW CREATE TABLE  `test`.`test_smallint`;
SHOW CREATE TABLE  `test`.`test_smallintu`;
SHOW CREATE TABLE  `test`.`test_text`;
SHOW CREATE TABLE  `test`.`test_time`;
SHOW CREATE TABLE  `test`.`test_timestamp`;
SHOW CREATE TABLE  `test`.`test_tinyblob`;
SHOW CREATE TABLE  `test`.`test_tinyint`;
SHOW CREATE TABLE  `test`.`test_tinyintu`;
SHOW CREATE TABLE  `test`.`test_tinytext`;
SHOW CREATE TABLE  `test`.`test_utf16`;
SHOW CREATE TABLE  `test`.`test_utf8`;
SHOW CREATE TABLE  `test`.`test_varbinary1`;
SHOW CREATE TABLE  `test`.`test_varbinary10`;
SHOW CREATE TABLE  `test`.`test_varbinary100`;
SHOW CREATE TABLE  `test`.`test_varbinary1000`;
SHOW CREATE TABLE  `test`.`test_varchar1`;
SHOW CREATE TABLE  `test`.`test_varchar255`;
SHOW CREATE TABLE  `test`.`test_year`;
SHOW CREATE TABLE  `test`.`test_year2`;
SHOW CREATE TABLE  `test`.`test_year4`;

How to repeat:
execute:
show columns

[19 Jul 2011 5:48] Valeriy Kravchuk

Please, send the output of Help > System Info menu item.

Next time you'll see this crash, please, right click somewhere in the error dialog box with no text and use Copy stack trace to clipboard context menu item. Send stack trace to this report.

[19 Jul 2011 19:36] Dann Corbit

This file contains the things requested by the email from the person working on this bug.

Attachment: info.txt (text/plain), 19.90 KiB.

[24 Aug 2011 17:06] Armando Lopez Valencia

Thanks a lot for your report Dann.
Can you please:
- Send the output of Help -> System Info menu item.
- Send us a dump of the DB.
Thanks.

[24 Sep 2011 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".