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.