[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 a mysql
:
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)
Environment:
System: Linux vexweb1 2.4.2-2smp #1 SMP Sun Apr 8 20
to 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
Description
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