* Carl Troein > 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;
FYI: I tried this on my win2000 3.23.30-gamma server, it crashed. If I remove "BINARY" or "GROUP BY t", it does not crash. -- Roger --------------------------------------------------------------------- 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