Merge branch '10.6' into 10.7

5 files changed, 2361 insertions, 2291 deletions

diff --git a/mysql-test/suite/rpl/r/rpl_row_img_sequence.result b/mysql-test/suite/rpl/r/rpl_row_img_sequence.result
deleted file mode 100644
index aa9fb34ec02..00000000000
--- a/mysql-test/suite/rpl/r/rpl_row_img_sequence.result
+++ /dev/null
@@ -1,2290 +0,0 @@
-include/rpl_init.inc [topology=1->2->3]
-connection server_1;
-connection server_2;
-connection server_3;
-connection server_1;
-#
-# Test Case 1) binlog_row_image=MINIMAL should write only columns
-# 1 and 8 to the binary log
-#
-CON: 'server_1', IMG: 'MINIMAL', RESTART SLAVE: 'N'
-connection server_1;
-SET SESSION binlog_row_image= 'MINIMAL';
-SET GLOBAL binlog_row_image= 'MINIMAL';
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	MINIMAL
-CON: 'server_2', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
-connection server_2;
-SET SESSION binlog_row_image= 'MINIMAL';
-SET GLOBAL binlog_row_image= 'MINIMAL';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	MINIMAL
-CON: 'server_3', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
-connection server_3;
-SET SESSION binlog_row_image= 'MINIMAL';
-SET GLOBAL binlog_row_image= 'MINIMAL';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	MINIMAL
-connection server_1;
-### engines: MyISAM, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-#
-# Test Case 2) binlog_row_image=NOBLOB should write all columns to the
-# binary log
-#
-CON: 'server_1', IMG: 'NOBLOB', RESTART SLAVE: 'N'
-connection server_1;
-SET SESSION binlog_row_image= 'NOBLOB';
-SET GLOBAL binlog_row_image= 'NOBLOB';
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	NOBLOB
-CON: 'server_2', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
-connection server_2;
-SET SESSION binlog_row_image= 'NOBLOB';
-SET GLOBAL binlog_row_image= 'NOBLOB';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	NOBLOB
-CON: 'server_3', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
-connection server_3;
-SET SESSION binlog_row_image= 'NOBLOB';
-SET GLOBAL binlog_row_image= 'NOBLOB';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	NOBLOB
-connection server_3;
-### engines: MyISAM, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-#
-# Test Case 3) binlog_row_image=NOBLOB should write all columns to the
-# binary log
-#
-CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
-connection server_1;
-SET SESSION binlog_row_image= 'FULL';
-SET GLOBAL binlog_row_image= 'FULL';
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	FULL
-CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
-connection server_2;
-SET SESSION binlog_row_image= 'FULL';
-SET GLOBAL binlog_row_image= 'FULL';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	FULL
-CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
-connection server_3;
-SET SESSION binlog_row_image= 'FULL';
-SET GLOBAL binlog_row_image= 'FULL';
-include/stop_slave.inc
-include/start_slave.inc
-FLUSH TABLES;
-SHOW VARIABLES LIKE 'binlog_row_image';
-Variable_name	Value
-binlog_row_image	FULL
-connection server_3;
-### engines: MyISAM, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: MyISAM, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, MyISAM, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, MyISAM
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-### engines: InnoDB, InnoDB, InnoDB
-# Create sequences with specific engines per server
-connection server_1;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/save_master_gtid.inc
-connection server_2;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-connection server_3;
-SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
-include/sync_with_master_gtid.inc
-# Pt.1 Ensure SETVAL replicates and binlogs correctly
-connection server_1;
-SELECT SETVAL(s1, 10);
-SETVAL(s1, 10)
-10
-include/save_master_gtid.inc
-# Validate SETVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged SETVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged SETVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged SETVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
-connection server_1;
-SELECT NEXTVAL(s1);
-NEXTVAL(s1)
-11
-include/save_master_gtid.inc
-# Validate NEXTVAL replicated correctly to other servers
-connection server_3;
-include/sync_with_master_gtid.inc
-include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
-# Validate server_1 binlogged NEXTVAL with the correct columns
-connection server_1;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_2 binlogged NEXTVAL with the correct columns
-connection server_2;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Validate server_3 binlogged NEXTVAL with the correct columns
-connection server_3;
-FLUSH LOGS;
-include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
-# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
-# Verifying all expected column ids appear in binlog event output..
-# ..success
-# Verifying only expected column ids appear in binlog event output..
-# ..success
-# Cleanup
-connection server_1;
-DROP TABLE s1;
-include/save_master_gtid.inc
-connection server_3;
-include/sync_with_master_gtid.inc
-include/rpl_end.inc
-# End of tests
diff --git a/mysql-test/suite/rpl/r/rpl_row_img_sequence_full.result b/mysql-test/suite/rpl/r/rpl_row_img_sequence_full.result
new file mode 100644
index 00000000000..2303911637f
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_row_img_sequence_full.result
@@ -0,0 +1,767 @@
+include/rpl_init.inc [topology=1->2->3]
+connection server_1;
+connection server_2;
+connection server_3;
+connection server_1;
+#
+# binlog_row_image=FULL should write all columns to the binary log
+#
+CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
+connection server_1;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_2;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_3;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+connection server_1;
+### engines: MyISAM, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+include/rpl_end.inc
+# End of tests
diff --git a/mysql-test/suite/rpl/r/rpl_row_img_sequence_min.result b/mysql-test/suite/rpl/r/rpl_row_img_sequence_min.result
new file mode 100644
index 00000000000..eaf770f245c
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_row_img_sequence_min.result
@@ -0,0 +1,797 @@
+include/rpl_init.inc [topology=1->2->3]
+connection server_1;
+connection server_2;
+connection server_3;
+connection server_1;
+#
+# binlog_row_image=MINIMAL should write only columns 1 and 8 to the
+# binary log
+#
+CON: 'server_1', IMG: 'MINIMAL', RESTART SLAVE: 'N'
+connection server_1;
+SET SESSION binlog_row_image= 'MINIMAL';
+SET GLOBAL binlog_row_image= 'MINIMAL';
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	MINIMAL
+CON: 'server_2', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
+connection server_2;
+SET SESSION binlog_row_image= 'MINIMAL';
+SET GLOBAL binlog_row_image= 'MINIMAL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	MINIMAL
+CON: 'server_3', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
+connection server_3;
+SET SESSION binlog_row_image= 'MINIMAL';
+SET GLOBAL binlog_row_image= 'MINIMAL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	MINIMAL
+connection server_1;
+### engines: MyISAM, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
+connection server_1;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_2;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_3;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+connection server_3;
+include/rpl_end.inc
+# End of tests
diff --git a/mysql-test/suite/rpl/r/rpl_row_img_sequence_noblob.result b/mysql-test/suite/rpl/r/rpl_row_img_sequence_noblob.result
new file mode 100644
index 00000000000..496bd8dc6b8
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_row_img_sequence_noblob.result
@@ -0,0 +1,796 @@
+include/rpl_init.inc [topology=1->2->3]
+connection server_1;
+connection server_2;
+connection server_3;
+connection server_1;
+#
+# binlog_row_image=NOBLOB should write all columns to the binary logs
+#
+CON: 'server_1', IMG: 'NOBLOB', RESTART SLAVE: 'N'
+connection server_1;
+SET SESSION binlog_row_image= 'NOBLOB';
+SET GLOBAL binlog_row_image= 'NOBLOB';
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	NOBLOB
+CON: 'server_2', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
+connection server_2;
+SET SESSION binlog_row_image= 'NOBLOB';
+SET GLOBAL binlog_row_image= 'NOBLOB';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	NOBLOB
+CON: 'server_3', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
+connection server_3;
+SET SESSION binlog_row_image= 'NOBLOB';
+SET GLOBAL binlog_row_image= 'NOBLOB';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	NOBLOB
+connection server_1;
+### engines: MyISAM, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: MyISAM, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, MyISAM, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, MyISAM
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+### engines: InnoDB, InnoDB, InnoDB
+# Create sequences with specific engines per server
+connection server_1;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/save_master_gtid.inc
+connection server_2;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+connection server_3;
+SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
+include/sync_with_master_gtid.inc
+# Pt.1 Ensure SETVAL replicates and binlogs correctly
+connection server_1;
+SELECT SETVAL(s1, 10);
+SETVAL(s1, 10)
+10
+include/save_master_gtid.inc
+# Validate SETVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged SETVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged SETVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged SETVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Pt.2 Ensure NEXTVAL replicates and binlogs correctly
+connection server_1;
+SELECT NEXTVAL(s1);
+NEXTVAL(s1)
+11
+include/save_master_gtid.inc
+# Validate NEXTVAL replicated correctly to other servers
+connection server_3;
+include/sync_with_master_gtid.inc
+include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
+# Validate server_1 binlogged NEXTVAL with the correct columns
+connection server_1;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_2 binlogged NEXTVAL with the correct columns
+connection server_2;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Validate server_3 binlogged NEXTVAL with the correct columns
+connection server_3;
+FLUSH LOGS;
+include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
+# MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
+# Verifying all expected column ids appear in binlog event output..
+# ..success
+# Verifying only expected column ids appear in binlog event output..
+# ..success
+# Cleanup
+connection server_1;
+DROP TABLE s1;
+include/save_master_gtid.inc
+connection server_3;
+include/sync_with_master_gtid.inc
+CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
+connection server_1;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_2;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
+connection server_3;
+SET SESSION binlog_row_image= 'FULL';
+SET GLOBAL binlog_row_image= 'FULL';
+include/stop_slave.inc
+include/start_slave.inc
+FLUSH TABLES;
+SHOW VARIABLES LIKE 'binlog_row_image';
+Variable_name	Value
+binlog_row_image	FULL
+connection server_3;
+include/rpl_end.inc
+# End of tests
diff --git a/mysql-test/suite/rpl/r/rpl_sp.result b/mysql-test/suite/rpl/r/rpl_sp.result
index 3c3fed4d9cf..0bb3d9dc52a 100644
--- a/mysql-test/suite/rpl/r/rpl_sp.result
+++ b/mysql-test/suite/rpl/r/rpl_sp.result
@@ -305,7 +305,7 @@ a
 100
 connection con1;
 create trigger trg before insert on t1 for each row set new.a= 10;
-ERROR 42000: TRIGGER command denied to user 'zedjzlcsjhd'@'localhost' for table 't1'
+ERROR 42000: TRIGGER command denied to user 'zedjzlcsjhd'@'localhost' for table `mysqltest1`.`t1`
 connection master;
 delete from t1;
 create trigger trg before insert on t1 for each row set new.a= 10;