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 tables? Or have you tried this on
>multiple tables to get the same effect?
Neil:
Yes, I tried it on other tables, and with various data types also.
Perhaps it is a version-specific thing. I'm running 3.23.47. What
version are you running?
Thanks,
s.s.
>>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 prompt will
>cause the MySQL server to crash and restart.
>
>create temporary table wassup (
> rowid int not null AUTO_INCREMENT PRIMARY KEY,
> col1 varchar(10) null );
>insert into wassup
>(col1)
>values
>('aaa'),
>('AAA'),
>(NULL)
>;
>
>select distinct binary col1 from wassup;
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
