diff options
| author | Bjorn Munch <bjorn.munch@oracle.com> | 2011-03-31 11:22:54 +0200 |
|---|---|---|
| committer | Bjorn Munch <bjorn.munch@oracle.com> | 2011-03-31 11:22:54 +0200 |
| commit | 64b8f1414ba35052fe4938a4adc1520f8d096b35 (patch) | |
| tree | 8e16ad588280679683356e7e07d6730961780d0c /mysql-test/extra | |
| parent | 9cd8fc9a61d5a1db994a192293aedfe739e521ff (diff) | |
| parent | ffb98660d2f9f40fbae675965bcfaea22c9985eb (diff) | |
| download | mariadb-git-64b8f1414ba35052fe4938a4adc1520f8d096b35.tar.gz | |
merge from 5.1 main
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 |