[EMAIL PROTECTED] writes:
> >Description:
>
>Executing a SELECT DISTINCT statement in conjunction
>with the BINARY cast operator will crash MySQL server
>when the column being cast contains one or more null
>values.
>
>
>
> >How-To-Repeat:
>
> Executing the following code from
On Wed, 30 Jan 2002 08:21:49 +1000, you wrote:
>I tried this on an existing table using a char(50) column with 956 entries,
>of which I have 1 valid entry and 954 NULL values. I have 2 records returned
>1 = valid entry, 1 = NULL and mysql did not crash.
>Is it only when you are using temporary ta
get the same effect?
Neil Silvester
Webmaster
Heat and Control Pty Ltd
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 30 January 2002 7:45 AM
To: [EMAIL PROTECTED]
Subject: SELECT DISTINCT BINARY crashes mysql on null values
>Descript
tor:Steve Severance
>Organization:
>MySQL support: none
>Synopsis: SELECT DISTINCT BINARY crashes mysql on null values
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Official MySQL RPM)
&
