2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
11
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
1
include/master-slave.inc
13
4
CREATE TABLE t1 (c1 BIT, c2 INT) Engine=InnoDB;
14
5
INSERT INTO `t1` VALUES ( 1, 1 );
15
6
UPDATE t1 SET c1=NULL where c2=1;
16
Comparing tables master:test.t1 and slave:test.t1
7
include/diff_tables.inc [master:t1, slave:t1]
17
8
DELETE FROM t1 WHERE c2=1 LIMIT 1;
18
Comparing tables master:test.t1 and slave:test.t1
9
include/diff_tables.inc [master:t1, slave:t1]
21
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
24
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
26
12
CREATE TABLE t1 (c1 CHAR) Engine=InnoDB;
27
13
INSERT INTO t1 ( c1 ) VALUES ( 'w' ) ;
31
17
UPDATE t1 SET c1=NULL WHERE c1='w';
32
Comparing tables master:test.t1 and slave:test.t1
18
include/diff_tables.inc [master:t1, slave:t1]
33
19
DELETE FROM t1 LIMIT 2;
34
Comparing tables master:test.t1 and slave:test.t1
20
include/diff_tables.inc [master:t1, slave:t1]