Bug #111483 | Different truncated result between select and delete | ||
---|---|---|---|
Submitted: | 19 Jun 2023 8:48 | Modified: | 19 Jun 2023 13:25 |
Reporter: | Siyang Weng | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0.33 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[19 Jun 2023 8:48]
Siyang Weng
[19 Jun 2023 13:25]
MySQL Verification Team
Hi Mr. Weng, Thank you for your bug report. However, it is not a bug. In SELECT, MySQL does its best to accommodate two completely different data types.being DOUBLE and CHAR / VARCHAR. This SELECT usually returns a warning, when that (warning) command is executed. That is because SELECT is a read-only statement and can not change data. However, with DELETE, more strict typing is required in order to prevent the erasure by mistake. Not a bug.