diff options
| author | Luis Soares <luis.soares@oracle.com> | 2011-03-25 12:13:17 +0000 |
|---|---|---|
| committer | Luis Soares <luis.soares@oracle.com> | 2011-03-25 12:13:17 +0000 |
| commit | 9b505d023732d41372dd6704a28557707a4fc234 (patch) | |
| tree | 55c54aa4488de8c12de54a3a7c208a808f3cb13c /mysql-test/extra | |
| parent | 11ca6e2ca403e2eb6e79b92110032cfe01a9d8bb (diff) | |
| parent | f24b6702e96cabf12c43e99d0b27276fcbce5d43 (diff) | |
| download | mariadb-git-9b505d023732d41372dd6704a28557707a4fc234.tar.gz | |
BUG#11766865: Automerged mysql-5.1 into mysql-5.5.
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 |