Edit File: rpl_row_img_sanity.result
include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] call mtr.add_suppression("Slave: Can\'t find record in \'t\' Error_code: 1032"); call mtr.add_suppression("Slave SQL: .*Could not execute Update_rows event on table test.t; Can.t find record in .t.* Error_code: 1032"); call mtr.add_suppression("The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state"); SHOW VARIABLES LIKE 'binlog_row_image'; Variable_name Value binlog_row_image FULL SET @old_binlog_row_image= @@binlog_row_image; SET @old_binlog_row_image= @@binlog_row_image; ##################################################### # basic assertion that binlog_row_image='FULL' is the # default ##################################################### CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' 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 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1)); INSERT INTO t(c1,c3) VALUES (1, 'a'); UPDATE t SET c1=2 WHERE c1=1;; DELETE FROM t;; DROP TABLE t; include/sync_slave_sql_with_master.inc SET @img_types= 'MINIMAL NOBLOB FULL'; CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' Variable_name Value binlog_row_image MINIMAL CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image MINIMAL ITERATIONS: row_img: MINIMAL, indexes: UK-NOT-NULL include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL' CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: MINIMAL, indexes: PK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'PK' CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: MINIMAL, indexes: UK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK' CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: MINIMAL, indexes: K include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'K' CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: MINIMAL, indexes: NONE include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'NONE' CREATE TABLE t (c1 int, c2 int, c3 blob); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N' Variable_name Value binlog_row_image NOBLOB CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image NOBLOB ITERATIONS: row_img: NOBLOB, indexes: UK-NOT-NULL include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL' CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: NOBLOB, indexes: PK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'PK' CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: NOBLOB, indexes: UK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK' CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: NOBLOB, indexes: K include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'K' CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: NOBLOB, indexes: NONE include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'NONE' CREATE TABLE t (c1 int, c2 int, c3 blob); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N' Variable_name Value binlog_row_image FULL CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image FULL ITERATIONS: row_img: FULL, indexes: UK-NOT-NULL include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL' CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: FULL, indexes: PK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'PK' CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: FULL, indexes: UK include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'UK' CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: FULL, indexes: K include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'K' CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1)); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ITERATIONS: row_img: FULL, indexes: NONE include/rpl_reset.inc CREATING TABLE IN master WITH INDEX 'NONE' CREATE TABLE t (c1 int, c2 int, c3 blob); include/sync_slave_sql_with_master.inc INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc SET @img_types= 'MINIMAL NOBLOB FULL'; CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' Variable_name Value binlog_row_image MINIMAL CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image MINIMAL ITERATIONS: row_img: MINIMAL include/rpl_reset.inc include/sync_slave_sql_with_master.inc include/sync_slave_sql_with_master.inc include/rpl_reset.inc ####### MINIMAL PARTICULAR SCENARIO ###### include/sync_slave_sql_with_master.inc ####### MINIMAL OTHER PARTICULAR SCENARIO ###### include/sync_slave_sql_with_master.inc CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N' Variable_name Value binlog_row_image NOBLOB CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image NOBLOB ITERATIONS: row_img: NOBLOB include/rpl_reset.inc include/sync_slave_sql_with_master.inc include/sync_slave_sql_with_master.inc include/rpl_reset.inc ####### NOBLOB PARTICULAR SCENARIO ###### include/sync_slave_sql_with_master.inc CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N' Variable_name Value binlog_row_image FULL CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' include/stop_slave.inc include/start_slave.inc Variable_name Value binlog_row_image FULL ITERATIONS: row_img: FULL include/rpl_reset.inc include/sync_slave_sql_with_master.inc include/sync_slave_sql_with_master.inc include/rpl_reset.inc ################## SPECIAL CASES ######################### include/rpl_reset.inc CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N' 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: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' 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 ################################### # PK (contains blob) ################################### CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1,c3(512))); INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c1=2 WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ################################### # PK (does not contain blob, but blob is updated) ################################### include/rpl_reset.inc CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1,c2)); INSERT INTO t VALUES (1,2,"a"); INSERT INTO t(c1,c3) VALUES (10,"a"); INSERT DELAYED INTO t(c1,c3) VALUES (100,"a"); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead INSERT INTO t(c1) VALUES (1000); INSERT DELAYED INTO t(c1) VALUES (10000); Warnings: Warning 1287 'INSERT DELAYED' is deprecated and will be removed in a future release. Please use INSERT instead UPDATE t SET c3='b' WHERE c1=1; DELETE FROM t WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ################################### # AUTOINC columns ################################### include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' 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 CREATE TABLE t (c1 int NOT NULL AUTO_INCREMENT, c2 int, c3 blob, primary key(c1,c2)); INSERT INTO t(c2) VALUES (2); DROP TABLE t; include/sync_slave_sql_with_master.inc ################################################################## # Test that slave does not write more columns than the ones it has ################################################################## include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int NOT NULL AUTO_INCREMENT, c2 int, c3 blob, primary key(c1,c2)); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int, c2 int, primary key(c1)); INSERT INTO t(c2,c3) VALUES (2,'aaaaa'); UPDATE t SET c2=3, c3='bbbbb' WHERE c2=2; DROP TABLE t; include/sync_slave_sql_with_master.inc ################################################################## # Test that slave fills default columns in its own columns ################################################################## include/rpl_reset.inc CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int, c2 int); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int, c2 int, c3 int DEFAULT 2005); INSERT INTO t(c1) VALUES (1); INSERT INTO t(c1) VALUES (2); SELECT * FROM t; c1 c2 c3 1 NULL 2005 2 NULL 2005 SELECT * FROM t; c1 c2 1 NULL 2 NULL DROP TABLE t; include/sync_slave_sql_with_master.inc ################################################################## # Test that slave uses partial BI when master contains more columns ################################################################## include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1, c3), unique key(c1)); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int NOT NULL, c2 int, unique key(c1)); INSERT INTO t VALUES (1, 2, 3); UPDATE t SET c2= 4 WHERE c1=1; SELECT * FROM t; c1 c2 1 4 SELECT * FROM t; c1 c2 c3 1 4 3 DROP TABLE t; include/sync_slave_sql_with_master.inc ################################################################## # Test that if master has binlog_row_image=MINIMAL and slave has # NOBLOB or FULL, it will log the expected columns ################################################################## include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1)); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, c4 blob, unique key(c1)); INSERT INTO t VALUES (1, 2, 3); UPDATE t SET c2= 4 WHERE c1=1; DELETE FROM t WHERE c2=4; DROP TABLE t; include/sync_slave_sql_with_master.inc include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1)); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, c4 blob, unique key(c1)); INSERT INTO t VALUES (1, 2, 3); UPDATE t SET c2= 4 WHERE c1=1; DELETE FROM t WHERE c2=4; DROP TABLE t; include/sync_slave_sql_with_master.inc ################################################################ # Test that the slave stop with error if no usable data is on BI ################################################################ include/rpl_reset.inc CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' 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 SET SQL_LOG_BIN=0; CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c3)); SET SQL_LOG_BIN=1; CREATE TABLE t (c1 int NOT NULL, c2 int, primary key(c1)); INSERT INTO t VALUES (1,2,3); UPDATE t SET c2=4 WHERE c2=2; DROP TABLE t; include/wait_for_slave_sql_error.inc [errno=1032] DROP TABLE t; include/rpl_reset.inc CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y' 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 CREATE TABLE t1(id INT PRIMARY KEY, a INT) ENGINE = INNODB; include/sync_slave_sql_with_master.inc INSERT INTO t1 (id, a) VALUES (1, 1); "Case: FULL - EXPLAIN output should not display Using temporary" EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range PRIMARY PRIMARY 4 const 1 Using where UPDATE t1 SET a=a+1 WHERE id < 2; CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N' 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: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y' 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 "Case: NOBLOB - EXPLAIN output should not display Using temporary" EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range PRIMARY PRIMARY 4 const 1 Using where UPDATE t1 SET a=a+1 WHERE id < 2; CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N' 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: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y' 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 EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range PRIMARY PRIMARY 4 const 1 Using where UPDATE t1 SET a=a+1 WHERE id < 2; DROP TABLE t1; include/sync_slave_sql_with_master.inc SET GLOBAL binlog_row_image= @old_binlog_row_image; SET SESSION binlog_row_image= @old_binlog_row_image; SET GLOBAL binlog_row_image= @old_binlog_row_image; SET SESSION binlog_row_image= @old_binlog_row_image; include/rpl_end.inc