|
CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=LevelDB;
|
# Query OK, 0 rows affected (0.06 sec)
|
|
INSERT INTO t1 VALUES (2),(1);
|
# Query OK, 2 rows affected (0.01 sec)
|
# Records: 2 Duplicates: 0 Warnings: 0
|
|
SELECT * FROM t1 ORDER BY pk;
|
# ERROR 1030 (HY000): Got error 122 from storage engine
|
revision-id: psergey@askmonty.org-20121221152341-9stvnkuiinslrt9h
|
date: 2012-12-21 19:23:41 +0400
|
build-date: 2012-12-21 21:15:42 +0400
|
revno: 4471
|
branch: mysql-5.6-leveldb
|
Same happens with ORDER BY <non-pk column>
DELETE IGNORE .. ORDER BY .. causes an assertion failure, but I assume it's a result of the described problem.
|