Bug #100233 | bitwise and & produces wrong result | ||
---|---|---|---|
Submitted: | 16 Jul 2020 9:20 | Modified: | 16 Jul 2020 14:02 |
Reporter: | Yushan ZHANG | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any | |
Tags: | and, BINARY |
[16 Jul 2020 9:20]
Yushan ZHANG
[16 Jul 2020 14:02]
MySQL Verification Team
Hi Mr. ZHANG, Thank you for your bug report. However, this is not a bug. Our Reference Manual nicely documents that CONV() does not return a numeric value, hence result of any bitwise operator might not be what you expect. Not a bug.