Query that crashes MySQL

[James Fryer]

I'm using mysql-standard-4.1.0-alpha and I've found a query that 
consistently crashes the server.

The form of the query is this:

(SELECT DISTINCT g.id
    FROM T1 b, T2 g
    WHERE g.id IN (0)
) UNION (
    SELECT DISTINCT b.id
        FROM T1 b, T2 g
        WHERE g.id IN (0)
) LIMIT 1;
If I change the IN to '=' or remove the DISTINCTs then it no longer crashes.

I've run this query on Intel and Power PC architectures and the result is 
the same.

If I run in safe mode, the query no longer causes a crash. Unfortunately 
other parts of my application then slow down unacceptably.

In order to post a bug report I need to winnow down my tables and data to 
the minimum, which will take some effort. So before I do this, I'd like to 
ask if anyone else has seen this problem and if there is a fix.

Jim
--
James Fryer  /  [EMAIL PROTECTED]  /  [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]