Bug #74013 Throw an error in query parsing

• Submitted: 22 Sep 2014 13:51
• Reporter: Steel Brain
• Status: Open
• Category: MySQL Server
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any

[22 Sep 2014 13:51] Steel Brain

Description:
Currently if you execute a query that updates multiple rows and using `and` instead of commas to separate the parameters, it doesn't throw an error. and the developers often spends hours of time in bug hunting

How to repeat:
Update test.table set key_1 = 2 and key_2 =3 where id = 1;

Suggested fix:
Update test.table set key_1 = 2, key_2 = 3 where id = 1;