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 | f24b6702e96cabf12c43e99d0b27276fcbce5d43 (patch) | |
| tree | c59c42cfbc9887e17141280f9ae9d3517dad1c46 /mysql-test/extra | |
| parent | 4518a0ee8a6cbcfa1e28298701e70fcacfc6ced6 (diff) | |
| parent | b489c89f739850ab448182390982b88b536667f2 (diff) | |
| download | mariadb-git-f24b6702e96cabf12c43e99d0b27276fcbce5d43.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 |