[MDEV-6494] update ignore fails on overflow Created: 2014-07-28 Updated: 2022-09-08 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.38, 10.0.12, 10.1.0, 10.3.4 |
| Fix Version/s: | 5.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | upstream | ||
| Description |
|
dumb and probably upstream
|
| Comments |
| Comment by Elena Stepanova [ 2014-07-28 ] |
|
Reproducible on MySQL 5.5, 5.6, 5.7. |
| Comment by Nuno [ 2019-02-07 ] |
|
The same happens when you have an UNSIGNED BIGINT and you do -1 when the field is currently 0. I set NO_UNSIGNED_SUBTRACTION to ensure it doesn't overflow, but I want "UPDATE IGNORE" to not cause this query to fail. It should be a warning, not an error (with UPDATE IGNORE). |