Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # This tests MyISAM tables in transactions. No MyISAM updates arrive on the slave, but InnoDB ones do.
6 #
7
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 CREATE TABLE t2 (f1 INTEGER) ENGINE=MyISAM;
10 CREATE TABLE t3 (f1 INTEGER) ENGINE=MyISAM;
11
12 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t3 VALUES (NEW.f1);
13
14 SET AUTOCOMMIT=OFF;
15 START TRANSACTION;
16 INSERT INTO t1 VALUES (1);
17 INSERT INTO t2 VALUES (1);
18 COMMIT;
19
20 --connection node_2
21 SELECT COUNT(*) = 1 FROM t1;
22 SELECT COUNT(*) = 0 FROM t2;
23 SELECT COUNT(*) = 0 FROM t2;
24
25 --connection node_1
26 START TRANSACTION;
27 INSERT INTO t1 VALUES (1);
28 INSERT INTO t2 VALUES (1);
29 ROLLBACK;
30
31 --connection node_2
32 SELECT COUNT(*) = 1 FROM t1;
33 SELECT COUNT(*) = 0 FROM t2;
34 SELECT COUNT(*) = 0 FROM t2;
35
36 DROP TABLE t1, t2, t3;
37
38 #
39 # MDEV-25201 : Assertion `thd->wsrep_trx_meta.gtid.seqno == (-1)' failed in int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*)
40 #
41 SET SESSION lock_wait_timeout=2;
42 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
43 CREATE TEMPORARY TABLE t1 (i INT, PRIMARY KEY pk (i)) ENGINE=MyISAM;
44 PREPARE stmt FROM "INSERT INTO t1 (id) SELECT * FROM (SELECT 4 AS i) AS y";
45 INSERT INTO t1 VALUES(4);
46 DEALLOCATE PREPARE stmt;
47 COMMIT;
48 DROP TABLE t1;
49 SET GLOBAL wsrep_mode = DEFAULT;