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.
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".
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders. It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.