Ok, so it seems to be a bug. What's the procedure for reporting it (or do the developers read this list?)
-David A minimal test case that demonstrates the bug: create table t ( id integer, index id_idx(id) ); insert into t(id) values(null); select * from t; delete from t where id <=> 1; select * from t; AB> I get the same behaviour with mysql 3.23.47 (not max) and with mysql v AB> 4.0.4-beta AB> Without the index it works fine. Must be a bug.... AB> Cheers, AB> Andrew --------------------------------------------------------------------- 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
