Bug #24959 Query resulting in empty set consistently crashes MySQL Query Browser
Submitted: 11 Dec 2006 15:54 Modified: 21 Dec 2006 7:26
Reporter: Jonathon Brenner Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.2.6beta OS:MacOS (Mac OS X 10.4.8 (Build 8L2127))
Assigned to: CPU Architecture:Any
Tags: crash, empty set, os x

[11 Dec 2006 15:54] Jonathon Brenner
Description:
Query resulting in empty set consistently crashes MySQL Query Browser

=============
Example Query
=============
SELECT * FROM se_events WHERE call_session_id = 637090

====================
Linux Client Results
====================
mysql> SELECT * FROM se_events WHERE call_session_id = 637090;
Empty set (2.87 sec)

mysql> desc se_events;
+----------------------+---------------+------+-----+---------+----------------+
| Field                | Type          | Null | Key | Default | Extra          |
+----------------------+---------------+------+-----+---------+----------------+
| id                   | int(11)       | NO   | PRI | NULL    | auto_increment | 
| call_session_id      | int(11)       | NO   |     | NULL    |                | 
| eventType            | varchar(2)    | NO   |     | NULL    |                | 
| eventTime            | int(11)       | NO   |     | NULL    |                | 
| globalCallID         | varchar(36)   | NO   |     | NULL    |                | 
| callLegID            | varchar(8)    | NO   |     | NULL    |                | 
| uniqueEndpointHandle | varchar(32)   | NO   |     | NULL    |                | 
| seqNum               | varchar(255)  | NO   |     | NULL    |                | 
| resourceType         | varchar(255)  | YES  |     | NULL    |                | 
| resourceGroup        | varchar(255)  | YES  |     | NULL    |                | 
| resourceID           | varchar(255)  | YES  |     | NULL    |                | 
| CallType             | varchar(255)  | YES  |     | NULL    |                | 
| SdpInfo              | varchar(1024) | YES  |     | NULL    |                | 
+----------------------+---------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

====================
MySQL Server Version
====================
mysql  Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu (x86_64) using readline 5.0

===========================
MySQL Query Browser Version
===========================
Version:	1.2.6beta
Last Modified:	11/21/06 5:39 AM
Kind:	Universal
Location:	/Applications/MySQL Tools/MySQL Query Browser.app

How to repeat:
Build 1.2.6b of the Query Browser.
Client system is OS X 10.4.8.
MySQL Server 5.0.22 SUSE LINUX 10.0 (X86-64)
 Packages:
 MySQL-devel-standard-5.0.22-0.sles9
 MySQL-client-standard-5.0.22-0.sles9
 MySQL-server-standard-5.0.22-0.sles9
 MySQL-shared-standard-5.0.22-0.sles9 

Execute a query that results in an empty set and the Query Browser immediately crashes.
[21 Dec 2006 7:26] 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