[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 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
> ;
Hi!
I tested your case and it worked just fine for me.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
