Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8
-
None
Description
Transporting the tablespace from 10.6 to 10.11 version shows the error even
though table schema matches. (descending order of index fields)
MariaDB [(none)]> use test;
|
Database changed
|
MariaDB [test]> create table t1(f1 int not null, f2 int not null, primary key(f1 desc))engine=innodb;
|
Query OK, 0 rows affected (0.027 sec)
|
|
|
MariaDB [test]> alter table t1 discard tablespace;
|
Query OK, 0 rows affected (0.018 sec)
|
|
|
MariaDB [test]> alter table t1 import tablespace;
|
ERROR 1808 (HY000): Schema mismatch (Index PRIMARY field f1 is DESC which does not match with .cfg file)
|
In other way around,transporting from 10.11 to 10.6, InnoDB ends in crash during
alter table rebuild operation using inplace algorithm:
|
|
MariaDB [test]> alter table t1_pk_desc import tablespace;
|
Query OK, 0 rows affected (0.030 sec)
|
|
|
MariaDB [test]> alter table t1_pk_desc force;
|
ERROR 2013 (HY000): Lost connection to server during query
|
|
|
mysqld: /home/thiru/source_file/server/10.6/storage/innobase/btr/btr0bulk.cc:173: void PageBulk::insertPage(rec_t*, rec_offs*) [with format <anonymous> = PageBulk::DYNAMIC; rec_t = unsigned char; rec_offs = short unsigned int]: Assertion `cmp_rec_rec(rec, old_rec, offsets, old_offsets, m_index
|
|