At 02:48 pm 20/04/04, Victor Pendleton wrote:
What does the explain look like for this query?
Like this:
mysql> explain (SELECT DISTINCT g.id
-> FROM Broadcast b, Genre g
-> WHERE g.id IN (0)
->
-> ) UNION (
-> SELECT DISTINCT b.id
-> FROM Broadcast b,
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 th
James Fryer <[EMAIL PROTECTED]> wrote:
> 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
>>
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 ch