Bug: BINARY, NULL, and GROUP BY - Miguel Angel Solorzano - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsBug: BINARY, NULL, and GROUP BY

From	Sent On	Attachments
Miguel Angel Solorzano	12 Jan 2002 03:28
Michael Widenius	16 Jan 2002 06:14

Subject:	Bug: BINARY, NULL, and GROUP BY
From:	Miguel Angel Solorzano (mig...@mysql.com)
Date:	01/12/2002 03:28:45 AM
List:	com.mysql.lists.bugs

At 12:13 12/01/2002 +0100, Carl Troein wrote: Hi!

Thanks you for the bug report I was be able to repeat in the 4.0.1 Windows release too.

Regards, Miguel

CREATE TABLE t1 (txt varchar(10) default NULL); INSERT INTO t1 VALUES ('aaa'); INSERT INTO t1 VALUES (NULL); SELECT BINARY txt AS t FROM t1 GROUP BY t;

On my Linux systems, and MySQL compiled with gcc 2.95.3, this invariably leads to a segfault. Removing the non-null row from t1 solves the problem, as does removing the row with null. Without BINARY everything works.

I'm no longer on the list, so if you reply to this mail with comments or questions that you think I should read, please be sure to include my address.

//Carl

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-solor=uol....@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php