diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_log_bin.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_log_bin.result | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_log_bin.result b/mysql-test/suite/galera/r/galera_log_bin.result new file mode 100644 index 00000000000..6411a1e3043 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_log_bin.result @@ -0,0 +1,58 @@ +CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t1 VALUES (1); +CREATE TABLE t2 (id INT) ENGINE=InnoDB; +INSERT INTO t2 VALUES (1); +INSERT INTO t2 VALUES (1); +SELECT COUNT(*) = 1 FROM t1; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 2 FROM t2; +COUNT(*) = 2 +1 +ALTER TABLE t1 ADD COLUMN f2 INTEGER; +FLUSH LOGS; +SHOW BINLOG EVENTS IN 'mysqld-bin.000002' LIMIT 4,18; +Log_name Pos Event_type Server_id End_log_pos Info +mysqld-bin.000002 # Gtid # # GTID 0-1-1 +mysqld-bin.000002 # Query # # use `test`; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB +mysqld-bin.000002 # Gtid # # BEGIN GTID 0-1-2 +mysqld-bin.000002 # Table_map # # table_id: 48 (test.t1) +mysqld-bin.000002 # Write_rows_v1 # # table_id: 48 flags: STMT_END_F +mysqld-bin.000002 # Xid # # COMMIT /* xid=2 */ +mysqld-bin.000002 # Gtid # # GTID 0-1-3 +mysqld-bin.000002 # Query # # use `test`; CREATE TABLE t2 (id INT) ENGINE=InnoDB +mysqld-bin.000002 # Gtid # # BEGIN GTID 0-1-4 +mysqld-bin.000002 # Table_map # # table_id: 49 (test.t2) +mysqld-bin.000002 # Write_rows_v1 # # table_id: 49 flags: STMT_END_F +mysqld-bin.000002 # Xid # # COMMIT /* xid=4 */ +mysqld-bin.000002 # Gtid # # BEGIN GTID 0-1-5 +mysqld-bin.000002 # Table_map # # table_id: 49 (test.t2) +mysqld-bin.000002 # Write_rows_v1 # # table_id: 49 flags: STMT_END_F +mysqld-bin.000002 # Xid # # COMMIT /* xid=5 */ +mysqld-bin.000002 # Gtid # # GTID 0-1-6 +mysqld-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN f2 INTEGER +SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1'; +COUNT(*) = 2 +1 +SHOW BINLOG EVENTS IN 'mysqld-bin.000003' LIMIT 3,18; +Log_name Pos Event_type Server_id End_log_pos Info +mysqld-bin.000003 # Gtid # # GTID 0-1-1 +mysqld-bin.000003 # Query # # use `test`; CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB +mysqld-bin.000003 # Gtid # # BEGIN GTID 0-1-2 +mysqld-bin.000003 # Table_map # # table_id: 30 (test.t1) +mysqld-bin.000003 # Write_rows_v1 # # table_id: 30 flags: STMT_END_F +mysqld-bin.000003 # Xid # # COMMIT /* xid=2 */ +mysqld-bin.000003 # Gtid # # GTID 0-1-3 +mysqld-bin.000003 # Query # # use `test`; CREATE TABLE t2 (id INT) ENGINE=InnoDB +mysqld-bin.000003 # Gtid # # BEGIN GTID 0-1-4 +mysqld-bin.000003 # Table_map # # table_id: 31 (test.t2) +mysqld-bin.000003 # Write_rows_v1 # # table_id: 31 flags: STMT_END_F +mysqld-bin.000003 # Xid # # COMMIT /* xid=4 */ +mysqld-bin.000003 # Gtid # # BEGIN GTID 0-1-5 +mysqld-bin.000003 # Table_map # # table_id: 31 (test.t2) +mysqld-bin.000003 # Write_rows_v1 # # table_id: 31 flags: STMT_END_F +mysqld-bin.000003 # Xid # # COMMIT /* xid=5 */ +mysqld-bin.000003 # Gtid # # GTID 0-1-6 +mysqld-bin.000003 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN f2 INTEGER +DROP TABLE t1; +DROP TABLE t2; |