[MDEV-14641] Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine Created: 2017-12-13  Updated: 2017-12-18  Resolved: 2017-12-18

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Storage Engine - MyISAM
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 10.0.34, 10.1.30, 10.2.12

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: regression


 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.
Generated at Thu Feb 08 08:15:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.