Re: SELECT DISTINCT BINARY crashes mysql on null values

2002-01-30 Thread Sinisa Milivojevic
[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

Re: SELECT DISTINCT BINARY crashes mysql on null values

2002-01-29 Thread Steve Severance
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

RE: SELECT DISTINCT BINARY crashes mysql on null values

2002-01-29 Thread Neil Silvester
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 tables? Or have you tried this on multiple tables to g