diff options
| author | istruewing@stella.local <> | 2007-11-15 11:36:50 +0100 |
|---|---|---|
| committer | istruewing@stella.local <> | 2007-11-15 11:36:50 +0100 |
| commit | 2ecdc68e55238bef8fb3d2062242f26365b828cb (patch) | |
| tree | 372f62623e5676acfeea87da5f46742825b3beba /mysql-test | |
| parent | 05d341d90efac26f298b6c393b0994426f4c92a6 (diff) | |
| download | mariadb-git-2ecdc68e55238bef8fb3d2062242f26365b828cb.tar.gz | |
Bug#22351 - handler::index_next_same() call to key_cmp_if_same() uses
the wrong buffer
Post-pushbuild fix
Added test case for better coverage.
Diffstat (limited to 'mysql-test')
| -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) |