Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.2, 10.7.8
-
OS: Ubuntu-20.04 LTS
Description
The error reported by the penultimate statement in a transaction is left over to COMMIT or ROLLBACK statements, and BEGIN statement of another transaction in the same session.
1. Test Case:
/* init */ CREATE TABLE t0(c0 BOOLEAN PRIMARY KEY NOT NULL); |
|
|
/* tx1 */ BEGIN; |
/* tx1 */ INSERT INTO t0 VALUES (2136509845); |
-- ERROR 1264 (22003): Out of range value for column 'c0' at row 1
|
/* tx1 */ COMMIT; |
/* tx1 */ SHOW WARNINGS; |
+-------+------+---------------------------------------------+ |
| Level | Code | Message | |
+-------+------+---------------------------------------------+ |
| Error | 1264 | Out of range value for column 'c0' at row 1 | |
+-------+------+---------------------------------------------+ |
|
|
In the same session |
/* tx1 */ BEGIN; |
/* tx1 */ SHOW WARNINGS; |
+-------+------+---------------------------------------------+ |
| Level | Code | Message | |
+-------+------+---------------------------------------------+ |
| Error | 1264 | Out of range value for column 'c0' at row 1 | |
+-------+------+---------------------------------------------+ |
We expect that COMMIT statement and BEGIN statement in the test case will not report a warning.