I am using mysql 3.23.41 and I discovered this bug.
Imagine you have a varchar column named nick.
If you send this query it correctly fails:
select * from users where nick = 0;
because data types are different but if you issue this one:
update users set psw = "mypsw" where nick = 0;
it modifies all data !!! as if "where nick = 0" were always true.
Bye, have a nice day
Daniele
---------------------------------------------------------------------
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
