diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result b/mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result index d9ebb52493b..ef40fd311d3 100644 --- a/mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result +++ b/mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result @@ -2,27 +2,39 @@ include/master-slave.inc [connection master] ## case #1 - last_null_bit_pos==0 in record_compare without X bit include/rpl_reset.inc +connection master; CREATE TABLE t1 (c1 bigint(20) DEFAULT 0, c2 bigint(20) DEFAULT 0, c3 bigint(20) DEFAULT 0, c4 varchar(1) DEFAULT '', c5 bigint(20) DEFAULT 0, c6 bigint(20) DEFAULT 0, c7 bigint(20) DEFAULT 0, c8 bigint(20) DEFAULT 0) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO t1 ( c5, c6 ) VALUES ( 1 , 35 ); INSERT INTO t1 ( c5, c6 ) VALUES ( NULL, 35 ); UPDATE t1 SET c5 = 'a'; +connection slave; include/diff_tables.inc [master:t1, slave:t1] +connection master; DROP TABLE t1; +connection slave; ## case #1.1 - last_null_bit_pos==0 in record_compare with X bit ## (1 column less and no varchar) include/rpl_reset.inc +connection master; CREATE TABLE t1 (c1 bigint(20) DEFAULT 0, c2 bigint(20) DEFAULT 0, c3 bigint(20) DEFAULT 0, c4 bigint(20) DEFAULT 0, c5 bigint(20) DEFAULT 0, c6 bigint(20) DEFAULT 0, c7 bigint(20) DEFAULT 0) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO t1 ( c5, c6 ) VALUES ( 1 , 35 ); INSERT INTO t1 ( c5, c6 ) VALUES ( NULL, 35 ); UPDATE t1 SET c5 = 'a'; +connection slave; include/diff_tables.inc [master:t1, slave:t1] +connection master; DROP TABLE t1; +connection slave; ## case #2 - X bit is wrongly set. include/rpl_reset.inc +connection master; CREATE TABLE t1 (c1 int, c2 varchar(1) default '') ENGINE=InnoDB DEFAULT CHARSET= latin1; INSERT INTO t1(c1) VALUES (10); INSERT INTO t1(c1) VALUES (NULL); UPDATE t1 SET c1= 0; +connection slave; include/diff_tables.inc [master:t1, slave:t1] +connection master; DROP TABLE t1; +connection slave; include/rpl_end.inc |