Bug #105784 | update a set not_null_column = null, not_null_column = 2 should not raise an err | ||
---|---|---|---|
Submitted: | 3 Dec 2021 3:53 | Modified: | 3 Dec 2021 5:58 |
Reporter: | Huaiyu Xu | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0, 5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[3 Dec 2021 3:53]
Huaiyu Xu
[3 Dec 2021 5:58]
MySQL Verification Team
Hello Huaiyu Xu, Thank you for the report and test case. regards, Umesh
[3 Dec 2021 8:49]
Roy Lyseng
Posted by developer: According to SQL standard, a target column shall not occur more than once in the SET clause of an UPDATE statement.