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
