Debian Codegraph @

mysql-test/suite/galera/t/mdev_21025.test

raw
1 #
2 # MDEV-21205
3 #
4 # Start transaction after INSERT IGNORE which had no effect and
5 # kept the transaction open caused an assertion on the following
6 # START TRANSACTION because the empty transaction was not properly
7 # terminated.
8 #
9
10 --source include/galera_cluster.inc
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
12 START TRANSACTION;
13 INSERT INTO t1 (f1) VALUES (1);
14
15 START TRANSACTION;
16 # This INSERT succeeds with duplicate key warning due to IGNORE clause
17 # and keeps the transaction open. The following START TRANSACTION causes
18 # an assertion if the bug is present.
19 INSERT IGNORE INTO t1 (f1) VALUES (1);
20 START TRANSACTION;
21
22 DROP TABLE t1;