Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.11.16, 11.4.10, 11.8.6
-
None
-
Can result in unexpected behaviour
-
An error during the execution of CREATE TEMPORARY TABLE…SELECT no longer results in a rollback of the entire transaction, but of the failing statement.
Description
Reusing the test case from MDEV-36787
--source include/have_innodb.inc
|
CREATE TABLE t (a INT) ENGINE=InnoDB; |
START TRANSACTION; |
SELECT * FROM t; |
SAVEPOINT A;
|
--error ER_WARN_DATA_OUT_OF_RANGE
|
CREATE TEMPORARY TABLE tmp (a TINYINT) ENGINE=InnoDB AS SELECT 256 AS a; |
ROLLBACK TO SAVEPOINT A; |
DROP TABLE t; |
this unexpectedly fails with "unknown savepoint", because the transaction was rolled back as a result of 387fe5ecc3a6.
It should be fixed as in d228f237f276. See also eba285f2a21f.
Attachments
Issue Links
- is caused by
-
MDEV-36787 Error 153: No savepoint with that name upon ROLLBACK TO SAVEPOINT, assertion failure
-
- Closed
-