summaryrefslogtreecommitdiff
path: root/mysql-test/suite/bugs
diff options
context:
space:
mode:
authormats@kindahl-laptop.dnsalias.net <>2007-12-05 20:00:14 +0100
committermats@kindahl-laptop.dnsalias.net <>2007-12-05 20:00:14 +0100
commiteca0172010924ab2f7958056ce96c3e7400fdb58 (patch)
tree765c8d4850f2afc52ed14acacbda74ef2762a538 /mysql-test/suite/bugs
parent60880ec8aed2cd4f2f1afce3fd40a56cd5d2c259 (diff)
downloadmariadb-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.result15
-rw-r--r--mysql-test/suite/bugs/t/rpl_bug31583.test21
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;
+