diff options
Diffstat (limited to 'mysql-test/extra/rpl_tests/rpl_extra_col_master.test')
-rw-r--r-- | mysql-test/extra/rpl_tests/rpl_extra_col_master.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_extra_col_master.test b/mysql-test/extra/rpl_tests/rpl_extra_col_master.test index 0559e93676b..47a44709fcc 100644 --- a/mysql-test/extra/rpl_tests/rpl_extra_col_master.test +++ b/mysql-test/extra/rpl_tests/rpl_extra_col_master.test @@ -253,9 +253,9 @@ some var char'; INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10: binary data'; INSERT into t31 set f1=1, f2=1, f3=1, f4='first'; - INSERT into t31 set f1=1, f2=1, f3=2, f4='second', + INSERT ignore into t31 set f1=1, f2=1, f3=2, f4='second', f9=2.2, f10='seven samurai', f28=222.222, f35='222'; - INSERT into t31 values (1, 1, 3, 'third', + INSERT ignore into t31 values (1, 1, 3, 'third', /* f5 BIGINT, */ 333333333333333333333333, /* f6 BLOB, */ '3333333333333333333333', /* f7 DATE, */ '2007-07-18', @@ -289,7 +289,7 @@ binary data'; /*f35 VARCHAR(257),*/ 'three times three' ); - INSERT into t31 values (1, 1, 4, 'fourth', + INSERT ignore into t31 values (1, 1, 4, 'fourth', /* f5 BIGINT, */ 333333333333333333333333, /* f6 BLOB, */ '3333333333333333333333', /* f7 DATE, */ '2007-07-18', @@ -408,7 +408,7 @@ connection master; update t31 set f5=555555555555555 where f3=6; update t31 set f2=2 where f3=2; update t31 set f1=NULL where f3=1; - update t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3; + update ignore t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3; --echo --echo ** Delete from Master ** |