Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (i INT) ENGINE=MYISAM |
PARTITION BY LIST(i) ( |
PARTITION p0 VALUES IN (1), |
PARTITION p1 VALUES IN (2) |
);
|
ALTER TABLE t1 ROW_FORMAT=COMPRESSED; |
ALTER TABLE t1 DROP PARTITION p1; |
SELECT * FROM t1; |
|
# Cleanup
|
DROP TABLE t1; |
MariaDB [test]> SELECT * FROM t1; |
ERROR 1030 (HY000): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM |
The error certainly started happening in 10.0 after this 5.5 merge:
commit da4503e956ee067947e504c6e73052d9d906742c
|
Merge: babbf8c b000e16
|
Author: Sergei Golubchik <serg@mariadb.org>
|
Date: Wed Oct 18 15:14:39 2017 +0200
|
|
Merge branch '5.5' into 10.0
|
However, I am not getting the failure on 5.5.
Also reproducible with 10.1, 10.2. Couldn't reproduce with MySQL 5.5, 5.6, 5.7.