Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/log_bin.inc
4
5 #
6 # This tests simple autocommit replication of MyISAM tables.
7 #
8
9 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
10
11 # Without a PK
12
13 CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM;
14
15 INSERT INTO t1 VALUES (1);
16 INSERT INTO t1 VALUES (2), (3);
17 # This is TOI
18 INSERT INTO t1 SELECT 4 FROM DUAL UNION ALL SELECT 5 FROM DUAL;
19
20 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=MyISAM;
21 INSERT INTO t2 VALUES (1);
22 INSERT INTO t2 VALUES (2), (3);
23 # This is TOI
24 INSERT INTO t2 SELECT 4 FROM DUAL UNION ALL SELECT 5 FROM DUAL;
25
26 # Error
27 --error ER_DUP_ENTRY
28 INSERT INTO t2 VALUES (6), (1);
29
30 # UPDATE
31
32 UPDATE t1 SET f1 = 9;
33 UPDATE t2 SET f1 = 9 WHERE f1 = 1;
34
35 # DELETE
36
37 DELETE FROM t1 WHERE f1 = 9;
38 DELETE FROM t2 WHERE f1 = 9;
39
40 SELECT * FROM t1 ORDER BY f1;
41 SELECT * FROM t2 ORDER BY f1;
42
43 --connection node_2
44 SELECT * FROM t1 ORDER BY f1;
45 SELECT * FROM t2 ORDER BY f1;
46
47 # TRUNCATE
48
49 TRUNCATE TABLE t1;
50 TRUNCATE TABLE t2;
51
52 SELECT * FROM t1 ORDER BY f1;
53 SELECT * FROM t2 ORDER BY f1;
54
55 --connection node_2
56 SELECT * FROM t1 ORDER BY f1;
57 SELECT * FROM t2 ORDER BY f1;
58
59 --connection node_1
60 SET GLOBAL wsrep_mode=DEFAULT;
61 DROP TABLE t1;
62 DROP TABLE t2;