Bug: BINARY, NULL, and GROUP BY
Hi!
Miguel == Miguel Angel Solorzano [EMAIL PROTECTED] writes:
Miguel At 12:13 12/01/2002 +0100, Carl Troein wrote:
Miguel Hi!
Miguel Thanks you for the bug report I was be able to repeat
Miguel in the 4.0.1 Windows release too.
Miguel Regards,
Miguel 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.
This is now fixed and pushed into the MySQL 4.0.2 source repository. If
nothing unexpected happens, we will start building binary releases of
MySQL 4.0.2 next week. (Note that because we will not do a release
while there is any not solved critical bug, it may from time to time
take longer than expected before a new release is available).
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
___/ 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
Bug: BINARY, NULL, and GROUP BY
Hours after I left this mailing list, I found a bug
in 3.23.47. Since it's so easy to reproduce the bug here,
I'll let this example speak for itself:
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
-
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
Bug: BINARY, NULL, and GROUP BY
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
-
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
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ 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
