|
In MySQL 5.7:
create table example (
|
name varchar(20) NOT NULL,
|
logblob blob NOT NULL,
|
created datetime NOT NULL,
|
primary key (name, created)
|
) engine=InnoDB default charset=utf8
|
partition by hash( to_days(created))
|
partitions 10;
|
Stop server & physically copy datadir, or remove MySQL binaries & replace with MariaDB binaries.
Start server.
Try to access table:
MariaDB [t38689]> select count(*) from example;
|
ERROR 1932 (42S02): Table 't38689.example' doesn't exist in engine
|
Try running mysql_upgrade:
Repairing tables
|
t38689.example
|
Error : Table 't38689.example' doesn't exist in engine
|
status : Operation failed
|
Problem confirmed with tables partitioned by HASH, COLUMN, KEY, RANGE, and LIST.
|
MySQL-5-7-C-238-varlibmysql.tgza