Bug #79525 Bugs at Mysql Server
Submitted: 4 Dec 2015 12:11 Modified: 4 Dec 2015 13:43
Reporter: iqbal Hussain Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.*.* OS:CentOS
Assigned to: CPU Architecture:Any
Tags: Bugs at Mysql

[4 Dec 2015 12:11] iqbal Hussain 
Description:
 
There is a serious issue in Mysql all versions that while executing wrong
query it update the one column branch_code to zero. this is the query
(update intra_staff set br_code=82 and staff_code=2918). look at the syntax
of the query its totally wrong where class is missing here so it should
give error. but this query executed successfully and updated all the
records of the table to zoro which is not mentioned in the query can any
one please tell me why is it so. why all the brach codes upadated to zero
which is no where mentioned in the query ?
Waiting for your replies thanks
Regard
Iqbal Hussain
PHP Devoloper

How to repeat:
if this type of query is executed syntax error should occur.

Suggested fix:
if this type of query is executed syntax error should occur.
[4 Dec 2015 13:43] MySQL Verification Team 
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=6583.