diff options
| author | unknown <mats@mysql.com> | 2005-02-14 18:39:33 +0100 |
|---|---|---|
| committer | unknown <mats@mysql.com> | 2005-02-14 18:39:33 +0100 |
| commit | 8a8d476453437b27df0bc7ff63d138c743df11f1 (patch) | |
| tree | b2047ef7136ef2e2aba15fe0f72b9b20ecbf106e /mysql-test/t/rpl_insert_id.test | |
| parent | 4c21a10f27c6a15690b5640352d23f1c111ac729 (diff) | |
| download | mariadb-git-8a8d476453437b27df0bc7ff63d138c743df11f1.tar.gz | |
Bug#8412: For replication to work correctly, the prologue and
epilogue to an SQL statement should not have an error code even
when the SQL statement itself has an error code.
mysql-test/r/rpl_insert_id.result:
Adding test to ensure that slave handles error statement gracefully.
mysql-test/t/rpl_insert_id.test:
Adding test to ensure that slave handles error statement gracefully.
sql/log.cc:
Setting error code to 0 for SQL statement prologue and epilogue.
Diffstat (limited to 'mysql-test/t/rpl_insert_id.test')
| -rw-r--r-- | mysql-test/t/rpl_insert_id.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_insert_id.test b/mysql-test/t/rpl_insert_id.test index a6da44de456..33d6516632a 100644 --- a/mysql-test/t/rpl_insert_id.test +++ b/mysql-test/t/rpl_insert_id.test @@ -62,3 +62,19 @@ drop table t2; save_master_pos; connection slave; sync_with_master; + +# +# Bug#8412: Error codes reported in binary log for CHARACTER SET, +# FOREIGN_KEY_CHECKS +# +connection master; +SET TIMESTAMP=1000000000; +CREATE TABLE t1 ( a INT UNIQUE ); +SET FOREIGN_KEY_CHECKS=0; +--error 1062 +INSERT INTO t1 VALUES (1),(1); +sync_slave_with_master; + + + + |