MySQL Bugs: #121167: Bug in update statement execution

Bug #121167	Bug in update statement execution
Submitted:	25 Aug 9:06
Reporter:	Rajesh Gc	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S1 (Critical)
Version:	8,4	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The DML statement Update is not validating the query syntax and updating 0 values for all the rows mentioned for the column name in the update statement.

Example:"update fa_voucherdetails set Credit=843583.74 and pacsid=911 and VoucherPkey=4234 and VoucherDetailID=348"

This query got updated with 0 values in the credit column as the developer wrote a wrong syntax in place of where he has wrongly used and the sql engine did not validate the syntax.

How to repeat:
Example:"update fa_voucherdetails set Credit=843583.74 and pacsid=911 and VoucherPkey=4234 and VoucherDetailID=348"