Debian Codegraph @

mysql-test/suite/galera/r/galera_log_bin_ext.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_2;
6 set global wsrep_on=OFF;
7 reset master;
8 set global wsrep_on=ON;
9 connection node_1;
10 set global wsrep_on=OFF;
11 reset master;
12 set global wsrep_on=ON;
13 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (1);
15 CREATE TABLE t2 (id INT) ENGINE=InnoDB;
16 INSERT INTO t2 VALUES (1);
17 INSERT INTO t2 VALUES (1);
18 connection node_2;
19 SELECT COUNT(*) = 1 FROM t1;
20 COUNT(*) = 1
21 1
22 SELECT COUNT(*) = 2 FROM t2;
23 COUNT(*) = 2
24 1
25 connection node_1;
26 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
27 include/show_binlog_events.inc
28 Log_name Pos Event_type Server_id End_log_pos Info
29 hostname1-bin.000001 # Gtid # # GTID #-#-#
30 hostname1-bin.000001 # Query # # use `test`; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB
31 hostname1-bin.000001 # Gtid # # BEGIN GTID #-#-#
32 hostname1-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
33 hostname1-bin.000001 # Table_map # # table_id: # (test.t1)
34 hostname1-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
35 hostname1-bin.000001 # Xid # # COMMIT /* XID */
36 hostname1-bin.000001 # Gtid # # GTID #-#-#
37 hostname1-bin.000001 # Query # # use `test`; CREATE TABLE t2 (id INT) ENGINE=InnoDB
38 hostname1-bin.000001 # Gtid # # BEGIN GTID #-#-#
39 hostname1-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
40 hostname1-bin.000001 # Table_map # # table_id: # (test.t2)
41 hostname1-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
42 hostname1-bin.000001 # Xid # # COMMIT /* XID */
43 hostname1-bin.000001 # Gtid # # BEGIN GTID #-#-#
44 hostname1-bin.000001 # Annotate_rows # # INSERT INTO t2 VALUES (1)
45 hostname1-bin.000001 # Table_map # # table_id: # (test.t2)
46 hostname1-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
47 hostname1-bin.000001 # Xid # # COMMIT /* XID */
48 hostname1-bin.000001 # Gtid # # GTID #-#-#
49 hostname1-bin.000001 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN f2 INTEGER
50 connection node_2;
51 Shutting down server ...
52 connection node_1;
53 Cleaning var directory ...
54 connection node_2;
55 Starting server ...
56 connection node_2;
57 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
58 COUNT(*) = 2
59 1
60 include/show_binlog_events.inc
61 Log_name Pos Event_type Server_id End_log_pos Info
62 hostname1-bin.000002 # Binlog_checkpoint # # hostname1-bin.000002
63 DROP TABLE t1;
64 DROP TABLE t2;
65 #cleanup
66 connection node_1;
67 SET GLOBAL wsrep_on=OFF;
68 RESET MASTER;
69 SET GLOBAL wsrep_on=ON;