David, ----- Original Message ----- From: "David Mechner" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 20, 2002 1:59 PM Subject: Re[2]: delete where column <=> null
> Ok, so it seems to be a bug. What's the procedure for reporting it (or > do the developers read this list?) yes we do. Thank you for the bug report! I have now forwarded this bug report to the public developer mailing list. > -David Regards, Heikki sql query > 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 > --------------------------------------------------------------------- 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