Bug #46948 | any incorrect update sql is executed strangely | ||
---|---|---|---|
Submitted: | 27 Aug 2009 2:34 | Modified: | 27 Aug 2009 3:52 |
Reporter: | ws lee | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.37 ( maybe all version) | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[27 Aug 2009 2:34]
ws lee
[27 Aug 2009 3:52]
Valeriy Kravchuk
This is NOT a bug. Your update test set a=101 and b=1 where id=1 is interpreted as update test set a=(101 and b=1) where id=1 Check http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html and UPDATE syntax.