diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_not_null_innodb.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_not_null_innodb.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_not_null_innodb.result b/mysql-test/suite/rpl/r/rpl_not_null_innodb.result index 1eaeaba05bb..2d53a525f2c 100644 --- a/mysql-test/suite/rpl/r/rpl_not_null_innodb.result +++ b/mysql-test/suite/rpl/r/rpl_not_null_innodb.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +connection master; SET SQL_LOG_BIN= 0; CREATE TABLE t1(`a` INT, `b` DATE DEFAULT NULL, `c` INT DEFAULT NULL, @@ -12,6 +13,7 @@ CREATE TABLE t4(`a` INT, `b` DATE DEFAULT NULL, `c` INT DEFAULT NULL, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; SET SQL_LOG_BIN= 1; +connection slave; CREATE TABLE t1(`a` INT, `b` DATE DEFAULT NULL, `c` INT DEFAULT NULL, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; @@ -23,6 +25,7 @@ PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; CREATE TABLE t4(`a` INT, `b` DATE DEFAULT '0000-00-00', PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; ************* EXECUTION WITH INSERTS ************* +connection master; INSERT INTO t1(a,b,c) VALUES (1, null, 1); INSERT INTO t1(a,b,c) VALUES (2,'1111-11-11', 2); INSERT INTO t1(a,b) VALUES (3, null); @@ -40,20 +43,24 @@ INSERT INTO t4(a,b) VALUES (3, null); INSERT INTO t4(a,c) VALUES (4, 4); INSERT INTO t4(a) VALUES (5); ************* SHOWING THE RESULT SETS WITH INSERTS ************* +connection slave; TABLES t1 and t2 must be equal otherwise an error will be thrown. include/diff_tables.inc [master:t1, slave:t1] include/diff_tables.inc [master:t2, slave:t2] TABLES t2 and t3 must be different. +connection master; SELECT * FROM t3 ORDER BY a; a b 1 NULL 2 1111-11-11 3 NULL +connection slave; SELECT * FROM t3 ORDER BY a; a b c 1 NULL 500 2 1111-11-11 500 3 NULL 500 +connection master; SELECT * FROM t4 ORDER BY a; a b c 1 NULL 1 @@ -61,6 +68,7 @@ a b c 3 NULL NULL 4 NULL 4 5 NULL NULL +connection slave; SELECT * FROM t4 ORDER BY a; a b 1 NULL @@ -69,26 +77,33 @@ a b 4 NULL 5 NULL ************* EXECUTION WITH UPDATES and REPLACES ************* +connection master; DELETE FROM t1; INSERT INTO t1(a,b,c) VALUES (1,'1111-11-11', 1); REPLACE INTO t1(a,b,c) VALUES (2,'1111-11-11', 2); UPDATE t1 set b= NULL, c= 300 where a= 1; REPLACE INTO t1(a,b,c) VALUES (2, NULL, 300); ************* SHOWING THE RESULT SETS WITH UPDATES and REPLACES ************* +connection slave; TABLES t1 and t2 must be equal otherwise an error will be thrown. include/diff_tables.inc [master:t1, slave:t1] ************* CLEANING ************* +connection master; DROP TABLE t1; DROP TABLE t2; DROP TABLE t3; DROP TABLE t4; +connection slave; +connection master; SET SQL_LOG_BIN= 0; CREATE TABLE t1 (`a` INT, `b` BIT DEFAULT NULL, `c` BIT DEFAULT NULL, PRIMARY KEY (`a`)) ENGINE= Innodb; SET SQL_LOG_BIN= 1; +connection slave; CREATE TABLE t1 (`a` INT, `b` BIT DEFAULT b'01', `c` BIT DEFAULT NULL, PRIMARY KEY (`a`)) ENGINE= Innodb; ************* EXECUTION WITH INSERTS ************* +connection master; INSERT INTO t1(a,b,c) VALUES (1, null, b'01'); INSERT INTO t1(a,b,c) VALUES (2,b'00', b'01'); INSERT INTO t1(a,b) VALUES (3, null); @@ -96,6 +111,8 @@ INSERT INTO t1(a,c) VALUES (4, b'01'); INSERT INTO t1(a) VALUES (5); ************* SHOWING THE RESULT SETS WITH INSERTS ************* TABLES t1 and t2 must be different. +connection slave; +connection master; SELECT a,b+0,c+0 FROM t1 ORDER BY a; a b+0 c+0 1 NULL 1 @@ -103,6 +120,7 @@ a b+0 c+0 3 NULL NULL 4 NULL 1 5 NULL NULL +connection slave; SELECT a,b+0,c+0 FROM t1 ORDER BY a; a b+0 c+0 1 NULL 1 @@ -111,6 +129,7 @@ a b+0 c+0 4 NULL 1 5 NULL NULL ************* EXECUTION WITH UPDATES and REPLACES ************* +connection master; DELETE FROM t1; INSERT INTO t1(a,b,c) VALUES (1,b'00', b'01'); REPLACE INTO t1(a,b,c) VALUES (2,b'00',b'01'); @@ -118,8 +137,11 @@ UPDATE t1 set b= NULL, c= b'00' where a= 1; REPLACE INTO t1(a,b,c) VALUES (2, NULL, b'00'); ************* SHOWING THE RESULT SETS WITH UPDATES and REPLACES ************* TABLES t1 and t2 must be equal otherwise an error will be thrown. +connection slave; include/diff_tables.inc [master:t1, slave:t1] +connection master; DROP TABLE t1; +connection slave; ################################################################################ # NULL ---> NOT NULL (STRICT MODE) # UNCOMMENT THIS AFTER FIXING BUG#43992 @@ -127,6 +149,7 @@ DROP TABLE t1; ################################################################################ # NULL ---> NOT NULL (NON-STRICT MODE) ################################################################################ +connection master; SET SQL_LOG_BIN= 0; CREATE TABLE t1(`a` INT NOT NULL, `b` INT, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; @@ -135,6 +158,7 @@ PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; CREATE TABLE t3(`a` INT NOT NULL, `b` INT, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; SET SQL_LOG_BIN= 1; +connection slave; CREATE TABLE t1(`a` INT NOT NULL, `b` INT NOT NULL, `c` INT NOT NULL, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; @@ -145,6 +169,7 @@ CREATE TABLE t3(`a` INT NOT NULL, `b` INT NOT NULL, `c` INT DEFAULT 500, PRIMARY KEY(`a`)) ENGINE=Innodb DEFAULT CHARSET=LATIN1; ************* EXECUTION WITH INSERTS ************* +connection master; INSERT INTO t1(a) VALUES (1); INSERT INTO t1(a, b) VALUES (2, NULL); INSERT INTO t1(a, b) VALUES (3, 1); @@ -159,26 +184,33 @@ REPLACE INTO t3(a, b) VALUES (5, null); REPLACE INTO t3(a, b) VALUES (3, null); UPDATE t3 SET b = NULL where a = 4; ************* SHOWING THE RESULT SETS ************* +connection master; +connection slave; +connection master; SELECT * FROM t1 ORDER BY a; a b 1 NULL 2 NULL 3 1 +connection slave; SELECT * FROM t1 ORDER BY a; a b c 1 0 0 2 0 0 3 1 0 +connection master; SELECT * FROM t2 ORDER BY a; a b 1 NULL 2 NULL 3 1 +connection slave; SELECT * FROM t2 ORDER BY a; a b c 1 0 NULL 2 0 NULL 3 1 NULL +connection master; SELECT * FROM t3 ORDER BY a; a b 1 NULL @@ -186,6 +218,7 @@ a b 3 NULL 4 NULL 5 NULL +connection slave; SELECT * FROM t3 ORDER BY a; a b c 1 0 500 @@ -193,7 +226,9 @@ a b c 3 0 500 4 0 500 5 0 500 +connection master; DROP TABLE t1; DROP TABLE t2; DROP TABLE t3; +connection slave; include/rpl_end.inc |