Bug #29114 Inoccert Table update, if incorrect update syntax
Submitted: 14 Jun 2007 16:55 Modified: 18 Jun 2007 15:25
Reporter: Oleg Ivanov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Parser Severity:S3 (Non-critical)
Version:5.0.41 OS:Windows (2k)
Assigned to: CPU Architecture:Any
Tags: incorrect update

[14 Jun 2007 16:55] Oleg Ivanov
Description:
This Sql query:

update `tablename` set a = 1 and b = 2 where c = 3

updating `tablename` incorrect, but resulting syntax error...

How to repeat:
also
[18 Jun 2007 15:25] MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=6583