diff options
| -rw-r--r-- | mysql-test/r/partition.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/partition.test | 10 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index aa6a64ac76e..b0ba901907f 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -289,6 +289,13 @@ select * from t1 where a = 4; a b 4 4 drop table t1; +CREATE TABLE t1 (c1 INT, c2 INT, PRIMARY KEY USING BTREE (c1,c2)) ENGINE=MEMORY +PARTITION BY KEY(c2,c1) PARTITIONS 4; +INSERT INTO t1 VALUES (0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6); +SELECT * FROM t1 WHERE c1 = 4; +c1 c2 +4 4 +DROP TABLE t1; CREATE TABLE t1 (a int) PARTITION BY LIST (a) PARTITIONS 1 diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index f986215ee89..8114b85c0f9 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -373,6 +373,16 @@ select * from t1 where a = 4; drop table t1; # +# Bug#22351 - handler::index_next_same() call to key_cmp_if_same() +# uses the wrong buffer +# +CREATE TABLE t1 (c1 INT, c2 INT, PRIMARY KEY USING BTREE (c1,c2)) ENGINE=MEMORY + PARTITION BY KEY(c2,c1) PARTITIONS 4; +INSERT INTO t1 VALUES (0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6); +SELECT * FROM t1 WHERE c1 = 4; +DROP TABLE t1; + +# # Bug #13438: Engine clause in PARTITION clause causes crash # CREATE TABLE t1 (a int) |