mariadb/mysql-test/suite/galera/t/MDEV-30804.test
Denis Protivensky 210db2935c MDEV-30804 Rollback multi-engine transaction requiring 2PC but committing in one phase
Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
2023-04-19 14:08:57 +02:00

21 lines
456 B
Text

#
# Test that transaction requiring two-phase commit and involving
# storage engines not supporting it rolls back with a message.
#
--source include/galera_cluster.inc
--source include/have_innodb.inc
--source include/have_aria.inc
CREATE TABLE t (a INT) ENGINE=Aria;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
START TRANSACTION;
INSERT INTO t VALUES ('1');
INSERT INTO t1 VALUES ('1');
--error ER_ERROR_DURING_COMMIT
COMMIT;
DROP TABLE t;
DROP TABLE t1;