diff options
author | mats@kindahl-laptop.dnsalias.net <> | 2007-12-05 20:00:14 +0100 |
---|---|---|
committer | mats@kindahl-laptop.dnsalias.net <> | 2007-12-05 20:00:14 +0100 |
commit | eca0172010924ab2f7958056ce96c3e7400fdb58 (patch) | |
tree | 765c8d4850f2afc52ed14acacbda74ef2762a538 /mysql-test/suite/bugs | |
parent | 60880ec8aed2cd4f2f1afce3fd40a56cd5d2c259 (diff) | |
download | mariadb-git-eca0172010924ab2f7958056ce96c3e7400fdb58.tar.gz |
BUG#31583 (5.1-telco-6.1 -> 5.1.22. Slave returns Error in unknown event):
In the patch for BUG#21842, the code for handling old rows events were
refactored. There were a bug in the refactored code (possibly introduced
after the patch for BUG#21842) that caused caused the refactored old events
to read a columns bitmap after image even though there is no such bitmap
for old events. As a result, the reading got out of sync, and started reading
invalid data.
This patch removes all trace of the after image column bitmap from the refactored
old events and removes functions that are no longer needed because they are empty.
Diffstat (limited to 'mysql-test/suite/bugs')
-rw-r--r-- | mysql-test/suite/bugs/r/rpl_bug31583.result | 15 | ||||
-rw-r--r-- | mysql-test/suite/bugs/t/rpl_bug31583.test | 21 |
2 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/suite/bugs/r/rpl_bug31583.result b/mysql-test/suite/bugs/r/rpl_bug31583.result new file mode 100644 index 00000000000..a5e38e9b2d8 --- /dev/null +++ b/mysql-test/suite/bugs/r/rpl_bug31583.result @@ -0,0 +1,15 @@ +stop slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +start slave; +CREATE TABLE t1 ( a INT, b INT DEFAULT -3 ); +INSERT INTO t1 VALUES (1, DEFAULT); +UPDATE t1 SET a = 3; +SELECT * FROM t1 ORDER BY a; +a b +3 -3 +SELECT * FROM t1 ORDER BY a; +a b +3 -3 diff --git a/mysql-test/suite/bugs/t/rpl_bug31583.test b/mysql-test/suite/bugs/t/rpl_bug31583.test new file mode 100644 index 00000000000..a8f4a5538ca --- /dev/null +++ b/mysql-test/suite/bugs/t/rpl_bug31583.test @@ -0,0 +1,21 @@ +# +# BUG#31583: 5.1-telco-6.1 -> 5.1.22. Slave returns Error in unknown event + +# This is a problem for any update statement replicating from an old +# server to a new server. The bug consisted of a new slave trying to +# read two column bitmaps, but there is only one available in the old +# format. + +# This test case should be executed replicating from an old server to +# a new server, so make sure you have one handy. + +source include/master-slave.inc; + +CREATE TABLE t1 ( a INT, b INT DEFAULT -3 ); + +INSERT INTO t1 VALUES (1, DEFAULT); +UPDATE t1 SET a = 3; +SELECT * FROM t1 ORDER BY a; +sync_slave_with_master; +SELECT * FROM t1 ORDER BY a; + |