Debian Codegraph @

mysql-test/suite/galera/t/MDEV-25731.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_aria.inc
3
4 --connection node_1
5 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
6 CREATE TABLE t1 (c1 int) ENGINE=MYISAM;
7 LOAD DATA INFILE '../../std_data/mdev-25731.dat' IGNORE INTO TABLE t1 LINES TERMINATED BY '\n';
8 SELECT COUNT(*) AS EXPECT_6 FROM t1;
9
10 --connection node_2
11 SELECT COUNT(*) AS EXPECT_6 FROM t1;
12
13 --connection node_1
14 ALTER TABLE t1 ENGINE=Aria;
15 SET GLOBAL wsrep_mode=REPLICATE_ARIA;
16 LOAD DATA INFILE '../../std_data/mdev-25731.dat' IGNORE INTO TABLE t1 LINES TERMINATED BY '\n';
17 SELECT COUNT(*) AS EXPECT_12 FROM t1;
18
19 --connection node_2
20 SELECT COUNT(*) AS EXPECT_12 FROM t1;
21
22 --connection node_1
23 ALTER TABLE t1 ENGINE=InnoDB;
24 LOAD DATA INFILE '../../std_data/mdev-25731.dat' IGNORE INTO TABLE t1 LINES TERMINATED BY '\n';
25 SELECT COUNT(*) AS EXPECT_18 FROM t1;
26
27 --connection node_2
28 SELECT COUNT(*) AS EXPECT_18 FROM t1;
29
30 --connection node_1
31 DROP TABLE t1;
32 SET GLOBAL wsrep_mode=DEFAULT;