Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-bugs-900.test

raw
1 #
2 # Statement with no side effects causes unnecessary full rollback
3 #
4
5 --source include/galera_cluster.inc
6
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
8 SET SESSION wsrep_trx_fragment_size=1;
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1);
11 # Let's cause some bogus error with a statement that
12 # does not cause any replication event.
13 # The following used to return error ER_LOCK_DEADLOCK
14 # and cause the entire transaction to be rolled back.
15 --error ER_GLOBAL_VARIABLE
16 SET SESSION wsrep_cluster_name = ' ';
17
18 INSERT INTO t1 VALUES (2);
19 COMMIT;
20
21 SELECT f1 AS expect_1_and_2 FROM t1;
22 DROP TABLE t1;