Bug #106554 | Unexpected behavior in UPDATE statement | ||
---|---|---|---|
Submitted: | 24 Feb 2022 7:07 | Modified: | 1 Mar 2022 8:15 |
Reporter: | John Jove | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.28, 5.7 | OS: | Ubuntu (20.04) |
Assigned to: | CPU Architecture: | x86 |
[24 Feb 2022 7:07]
John Jove
[24 Feb 2022 7:33]
MySQL Verification Team
Hello John Jove, Thank you for the report and feedback. regards, Umesh
[1 Mar 2022 8:15]
Roy Lyseng
Posted by developer: This is considered not a bug. MySQL is free to evaluate the arguments to the XOR operator, or evaluate whether the arguments are NULL. The latter can be considered an optimization, but we have currently no intention of implementing that.