summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_explicit_prune.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2020-07-17 12:20:23 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2020-07-17 12:20:23 +0400
commit2cae58f8918f64c77227cfa07ab2fd24c3580f81 (patch)
treeafc69562c22406442d109d15e201a9de60cfdca1 /mysql-test/main/partition_explicit_prune.result
parent73aa31fbfd793bdb597bb19c52118ab4e637f4bc (diff)
downloadmariadb-git-2cae58f8918f64c77227cfa07ab2fd24c3580f81.tar.gz
MDEV-18371 Server crashes in ha_innobase::cmp_ref upon UPDATE with PARTITION clause.
m_file[0] not always is a good sample.
Diffstat (limited to 'mysql-test/main/partition_explicit_prune.result')
-rw-r--r--mysql-test/main/partition_explicit_prune.result18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/partition_explicit_prune.result b/mysql-test/main/partition_explicit_prune.result
index 951b21db3e1..0c102501a9d 100644
--- a/mysql-test/main/partition_explicit_prune.result
+++ b/mysql-test/main/partition_explicit_prune.result
@@ -1888,4 +1888,22 @@ ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
SELECT * FROM t1 PARTITION (p0);
i
UNLOCK TABLES;
+DROP TABLE t1;
+#
+# MDEV-18371 Server crashes in ha_innobase::cmp_ref upon UPDATE with PARTITION clause.
+#
+CREATE TABLE t1 (a INT, b INT, KEY (a)) ENGINE=InnoDB PARTITION BY KEY(b) PARTITIONS 4;
+INSERT INTO t1 VALUES (3,0),(8,2),(7,8),(3,4),(2,4),(0,7),(4,3),(3,6);
+FLUSH TABLES;
+UPDATE t1 PARTITION (p3,p1) SET a = 2 WHERE a = 3;
+SELECT * FROM t1;
+a b
+2 0
+7 8
+2 4
+2 4
+0 7
+4 3
+8 2
+2 6
DROP TABLE t1, t2;