Debian Codegraph @

mysql-test/suite/galera/r/MDEV-25731.result

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