diff options
author | Luis Soares <luis.soares@oracle.com> | 2011-03-24 10:58:48 +0000 |
---|---|---|
committer | Luis Soares <luis.soares@oracle.com> | 2011-03-24 10:58:48 +0000 |
commit | ee1f95dcccdb2e1249edbbf21f465d075e64ec60 (patch) | |
tree | c59c42cfbc9887e17141280f9ae9d3517dad1c46 /mysql-test/extra | |
parent | 67319231e8c94b916d745b92021637509d498879 (diff) | |
parent | 16e4677c5db112bd387f83e410e2104659f95b20 (diff) | |
download | mariadb-git-ee1f95dcccdb2e1249edbbf21f465d075e64ec60.tar.gz |
Automerging bzr bundle attached to bug report into latest mysql-5.1.
Diffstat (limited to 'mysql-test/extra')
-rw-r--r-- | mysql-test/extra/rpl_tests/rpl_record_compare.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_record_compare.test b/mysql-test/extra/rpl_tests/rpl_record_compare.test index f29e4fb791a..210aee025d0 100644 --- a/mysql-test/extra/rpl_tests/rpl_record_compare.test +++ b/mysql-test/extra/rpl_tests/rpl_record_compare.test @@ -62,4 +62,24 @@ UPDATE t1 SET c1= 0; DROP TABLE t1; -- sync_slave_with_master +# +# BUG#11766865: 60091: RBR + NO PK + UPDATE NULL VALUE --> SLAVE BREAK WITH ERROR HA_ERR_END_OF_ +# + +--connection master +--source include/rpl_reset.inc +--connection master + +--eval CREATE TABLE t1 (c1 int(11) NOT NULL, c2 int(11) NOT NULL, c3 int(11) DEFAULT '-1') ENGINE=$engine DEFAULT CHARSET=latin1 +INSERT INTO t1 VALUES (1,2,NULL); +UPDATE t1 SET c1=1, c2=2, c3=-1 WHERE c1=1 AND c2=2 AND ISNULL(c3); + +--sync_slave_with_master + +--let $diff_tables=master:test.t1, slave:test.t1 +--source include/diff_tables.inc + +--connection master +DROP TABLE t1; +--sync_slave_with_master |