|
The problem also exists on MySQL 5.5/5.6 and filed as http://bugs.mysql.com/bug.php?id=67982
--source include/have_partition.inc
|
|
CREATE TABLE IF NOT EXISTS t1 ( a INT, b INT, KEY(b) )
|
ENGINE = MYISAM PARTITION BY LIST (a) (
|
PARTITION p0 VALUES IN (1, NULL),
|
PARTITION p1 VALUES IN (4, 6, 3),
|
PARTITION p2 VALUES IN (8, 2, 5)
|
);
|
INSERT INTO t1 VALUES (5,0), (6,3), (4,9), (8,4);
|
ALTER TABLE t1 DISABLE KEYS;
|
ALTER TABLE t1 REBUILD PARTITION p1;
|
DELETE FROM t1 WHERE a = 8 ORDER BY b, a LIMIT 1;
|
bug.mdev3978-4 [ fail ]
|
Test ended at 2012-12-28 03:48:24
|
|
CURRENT_TEST: bug.mdev3978-4
|
mysqltest: At line 12: query 'DELETE FROM t1 WHERE a = 8 ORDER BY b, a LIMIT 1' failed: 1030: Got error 124 "Wrong index given to function" from storage engine
|
revision-id: monty@askmonty.org-20121217203456-gjlhf7eslleda9rz
|
date: 2012-12-17 22:34:56 +0200
|
revno: 3597
|
branch: maria/5.5
|
Also reproducible on 10.0-base and on last release versions 5.5.28a and 10.0.0.
Not reproducible on MariaDB 5.3 or MySQL 5.1.
|