Bug #24603 Select query on empty table crashes MQB
Submitted: 26 Nov 2006 22:11 Modified: 30 Nov 2006 9:33
Reporter: Romain Eude Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.2.6beta OS:MacOS (Macosx 10.4.8 (Build 8L127))
Assigned to: CPU Architecture:Any
Tags: query crash

[26 Nov 2006 22:11] Romain Eude 
Description:
Connecting to a MySQL server version MySQL 5.0.18-max via socket, select a database, then select an empty table. Run a simple "select * from myTable" and the MQB crashes and closed.

MacosX crash report is attached.

How to repeat:
1- Open MQB
2- set a default Db and connect.
3- d'n'd a table from the treeview to the query area on the select button.
4- run "select * from table1 t1".
If table contains data, it works. if table is empty, MQB crashes.

Suggested fix:
none
[26 Nov 2006 22:15] Romain Eude 
attached DDL of table as well.

btw, MQB says it performs the query and then crashes...
[27 Nov 2006 7:13] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat with a newer version, 1.2.6  (from GUI Tolls 5.0r6), and inform about the results.
[28 Nov 2006 22:56] Romain Eude 
Updating to 1.2.6beta did not cut it.
It still crashes after a few secs...

see attached : DDL of table for testing.
[30 Nov 2006 9:33] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicates bug #23915