Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 include/rpl_reset.inc
4 connection master;
5 CREATE TABLE t1 (c1 BIT, c2 INT) Engine=InnoDB;
6 INSERT INTO `t1` VALUES ( 1, 1 );
7 UPDATE t1 SET c1=NULL where c2=1;
8 connection slave;
9 include/diff_tables.inc [master:t1, slave:t1]
10 connection master;
11 DELETE FROM t1 WHERE c2=1 LIMIT 1;
12 connection slave;
13 include/diff_tables.inc [master:t1, slave:t1]
14 connection master;
15 DROP TABLE t1;
16 connection slave;
17 include/rpl_reset.inc
18 connection master;
19 CREATE TABLE t1 (c1 CHAR) Engine=InnoDB;
20 INSERT INTO t1 ( c1 ) VALUES ( 'w' ) ;
21 SELECT * FROM t1;
22 c1
23 w
24 UPDATE t1 SET c1=NULL WHERE c1='w';
25 connection slave;
26 include/diff_tables.inc [master:t1, slave:t1]
27 connection master;
28 DELETE FROM t1 LIMIT 2;
29 connection slave;
30 include/diff_tables.inc [master:t1, slave:t1]
31 connection master;
32 DROP TABLE t1;
33 connection slave;
34 include/rpl_end.inc