Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
5 INSERT INTO t1 VALUES (1),(2),(3);
6 CREATE TABLE ts1 AS SELECT * FROM t1;
7 include/show_binlog_events.inc
8 Log_name Pos Event_type Server_id End_log_pos Info
9 mysqld-bin.000002 # Gtid # # BEGIN GTID #-#-#
10 mysqld-bin.000002 # Query # # use `test`; CREATE TABLE `ts1` (
11 `f1` int(11) NOT NULL
12 )
13 mysqld-bin.000002 # Annotate_rows # # CREATE TABLE ts1 AS SELECT * FROM t1
14 mysqld-bin.000002 # Table_map # # table_id: # (test.ts1)
15 mysqld-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
16 mysqld-bin.000002 # Xid # # COMMIT /* XID */
17 connection node_2;
18 include/show_binlog_events.inc
19 Log_name Pos Event_type Server_id End_log_pos Info
20 mysqld-bin.000003 # Gtid # # BEGIN GTID #-#-#
21 mysqld-bin.000003 # Query # # use `test`; CREATE TABLE `ts1` (
22 `f1` int(11) NOT NULL
23 )
24 mysqld-bin.000003 # Annotate_rows # # CREATE TABLE ts1 AS SELECT * FROM t1
25 mysqld-bin.000003 # Table_map # # table_id: # (test.ts1)
26 mysqld-bin.000003 # Write_rows_v1 # # table_id: # flags: STMT_END_F
27 mysqld-bin.000003 # Xid # # COMMIT /* XID */
28 BINLOG_POSITIONS_MATCH
29 1
30 DROP TABLE t1,ts1;
31 connection node_1;
32 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
33 CREATE TABLE ts1 AS SELECT * FROM t1;
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 mysqld-bin.000002 # Gtid # # BEGIN GTID #-#-#
37 mysqld-bin.000002 # Query # # use `test`; CREATE TABLE `ts1` (
38 `f1` int(11) NOT NULL
39 )
40 mysqld-bin.000002 # Query # # COMMIT
41 connection node_2;
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 mysqld-bin.000003 # Gtid # # BEGIN GTID #-#-#
45 mysqld-bin.000003 # Query # # use `test`; CREATE TABLE `ts1` (
46 `f1` int(11) NOT NULL
47 )
48 mysqld-bin.000003 # Query # # COMMIT
49 BINLOG_POSITIONS_MATCH
50 1
51 DROP TABLE t1,ts1;
52 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");