Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_rec_comp_innodb.result

raw
1 include/master-slave.inc
2 [connection master]
3 ## case #1 - last_null_bit_pos==0 in record_compare without X bit
4 include/rpl_reset.inc
5 connection master;
6 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;
7 INSERT INTO t1 ( c5, c6 ) VALUES ( 1 , 35 );
8 INSERT INTO t1 ( c5, c6 ) VALUES ( NULL, 35 );
9 UPDATE IGNORE t1 SET c5 = 'a';
10 connection slave;
11 include/diff_tables.inc [master:t1, slave:t1]
12 connection master;
13 DROP TABLE t1;
14 connection slave;
15 ## case #1.1 - last_null_bit_pos==0 in record_compare with X bit
16 ## (1 column less and no varchar)
17 include/rpl_reset.inc
18 connection master;
19 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;
20 INSERT INTO t1 ( c5, c6 ) VALUES ( 1 , 35 );
21 INSERT INTO t1 ( c5, c6 ) VALUES ( NULL, 35 );
22 UPDATE IGNORE t1 SET c5 = 'a';
23 connection slave;
24 include/diff_tables.inc [master:t1, slave:t1]
25 connection master;
26 DROP TABLE t1;
27 connection slave;
28 ## case #2 - X bit is wrongly set.
29 include/rpl_reset.inc
30 connection master;
31 CREATE TABLE t1 (c1 int, c2 varchar(1) default '') ENGINE=InnoDB DEFAULT CHARSET= latin1;
32 INSERT INTO t1(c1) VALUES (10);
33 INSERT INTO t1(c1) VALUES (NULL);
34 UPDATE t1 SET c1= 0;
35 connection slave;
36 include/diff_tables.inc [master:t1, slave:t1]
37 connection master;
38 DROP TABLE t1;
39 connection slave;
40 include/rpl_end.inc