Edit File: rpl_gtid_empty_transaction.result
include/rpl_init.inc [topology=1->2->3] Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. include/rpl_default_connections.inc include/rpl_reset.inc ==== Case 1A: Transaction filtered out ==== include/gtid_step_reset.inc CREATE TABLE t_ignore(id INT); INSERT INTO t_ignore VALUES (1); DROP TABLE t_ignore; CREATE TABLE t_ignore_wild(id INT); INSERT INTO t_ignore_wild VALUES (1); DROP TABLE t_ignore_wild; include/gtid_step_assert.inc [count=6, only_count=0] include/rpl_sync.inc ==== Case 1B: CREATE/ALTER/DROP TEMPORARY filtered out ==== CREATE TEMPORARY TABLE t_ignore(a INT); ALTER TABLE t_ignore ADD COLUMN b INT; INSERT INTO t_ignore VALUES (1, 2); DROP TEMPORARY TABLE t_ignore; CREATE TEMPORARY TABLE t_ignore_wild(a INT); ALTER TABLE t_ignore_wild ADD COLUMN b INT; INSERT INTO t_ignore_wild VALUES (1, 2); DROP TEMPORARY TABLE t_ignore_wild; include/gtid_step_assert.inc [count=8, only_count=0] include/rpl_sync.inc ==== Case 1C: database filters on slave applier ==== include/gtid_step_reset.inc CREATE DATABASE db_ignore; USE db_ignore; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); USE test; include/gtid_step_assert.inc [count=3, only_count=0] include/rpl_sync.inc include/assert.inc [db_ignore should not be created on slave] include/assert.inc [db_ignore should not be created on second slave] DROP DATABASE db_ignore; include/rpl_sync.inc ==== Case 1D: database filters on slave binary log ==== include/gtid_step_reset.inc CREATE DATABASE db_binlog_ignore; USE db_binlog_ignore; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1); USE test; include/gtid_step_assert.inc [count=3, only_count=0] include/rpl_sync.inc include/assert.inc [db_binlog_ignore should not be created on slave] include/assert.inc [db_binlog_ignore should not be created on second slave] DROP DATABASE db_binlog_ignore; include/rpl_sync.inc ==== Case 2A: temp table transaction not logged in row format ==== ---- Initialize ---- SET @save.binlog_format= @@global.binlog_format; SET @@global.binlog_format= row; include/restart_slave.inc ---- Test ---- include/gtid_step_reset.inc CREATE TEMPORARY TABLE t2 (a INT); ALTER TABLE t2 ADD COLUMN b INT; INSERT INTO t2 VALUES (1, 2); include/gtid_step_assert.inc [count=3, only_count=0] include/rpl_sync.inc ---- Clean up ---- DROP TEMPORARY TABLE t2; include/rpl_sync.inc SET @@global.binlog_format= @save.binlog_format; ==== Case 2B: transaction with no effect not logged in row format ==== ---- Initialize ---- SET @save.binlog_format= @@global.binlog_format; SET @@global.binlog_format= row; include/restart_slave.inc SET @@session.binlog_format= statement; CREATE TABLE t1(id INT) ENGINE = InnoDB; include/rpl_sync.inc INSERT INTO t1 VALUES (0); ---- Test ---- UPDATE t1 SET id= 1 WHERE id = 0; include/rpl_sync.inc ---- Clean up ---- DROP TABLE t1; include/rpl_sync.inc SET @@global.binlog_format= @save.binlog_format; ==== Case 3: explicit empty transaction on master ==== include/gtid_step_reset.inc SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1'; COMMIT; SET @@SESSION.GTID_NEXT = 'AUTOMATIC'; include/gtid_step_assert.inc [count=1, only_count=1] include/rpl_sync.inc ==== Case 4: Nothing logged for ROLLBACK transactions ==== ---- Initialize ---- CREATE TABLE t1 (a INT) ENGINE = InnoDB; ---- Test ---- include/gtid_step_reset.inc DROP TABLE t2; ERROR 42S02: Unknown table 'test.t2' INSERT INTO t1 VALUES (1, 1); ERROR 21S01: Column count doesn't match value count at row 1 BEGIN; INSERT INTO t1 VALUES (2); ROLLBACK; include/gtid_step_assert.inc [count=0, only_count=0] ---- Clean Up ---- DROP TABLE t1; include/rpl_end.inc