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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.0.34 [ 22613 ] | |
| Fix Version/s | 10.1.30 [ 22637 ] | |
| Fix Version/s | 10.2.12 [ 22810 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 84414 ] | MariaDB v4 [ 153345 ] |