What does the explain look like for this query? -----Original Message----- From: James Fryer To: [EMAIL PROTECTED] Sent: 4/20/04 8:08 AM Subject: Query that crashes MySQL
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]