Query: DELETE FROM .. ORDER BY .. LIMIT 1 failed: 1030 Got error 124 "Wrong index given to function" from storage engine

--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