Debian Codegraph @

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

raw
1 #
2 # MDEV-27806 GTIDs diverge after CTAS
3 #
4 --source include/galera_cluster.inc
5
6 --connection node_1
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
8 INSERT INTO t1 VALUES (1),(2),(3);
9 CREATE TABLE ts1 AS SELECT * FROM t1;
10 --let binlog_pos= `SELECT @@gtid_binlog_pos`
11
12 --let $MASTER_MYPORT=$NODE_MYPORT_1
13 --let $binlog_file=LAST
14 --let $binlog_limit=8,20
15 --source include/show_binlog_events.inc
16
17 --connection node_2
18 --let $binlog_limit=7,20
19 --source include/show_binlog_events.inc
20
21 --disable_query_log
22 --eval SELECT STRCMP(@@gtid_binlog_pos, "$binlog_pos") = 0 AS BINLOG_POSITIONS_MATCH;
23 --enable_query_log
24
25 DROP TABLE t1,ts1;
26
27
28 #
29 # Same as above, with empty CREATE TABLE AS SELECT
30 #
31 --connection node_1
32 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
33 CREATE TABLE ts1 AS SELECT * FROM t1;
34 --let binlog_pos= `SELECT @@gtid_binlog_pos`
35
36 --let $MASTER_MYPORT=$NODE_MYPORT_1
37 --let $binlog_file=LAST
38 --let $binlog_limit=18,20
39 --source include/show_binlog_events.inc
40
41 --connection node_2
42 --let $binlog_limit=17,20
43 --source include/show_binlog_events.inc
44
45 --disable_query_log
46 --eval SELECT STRCMP(@@gtid_binlog_pos, "$binlog_pos") = 0 AS BINLOG_POSITIONS_MATCH;
47 --enable_query_log
48
49 DROP TABLE t1,ts1;
50
51 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");