|
MySQL 5.7.21 fixed something related to the table performance_schema.file_instances. It turns out that in MariaDB, the table is not reflecting to RENAME TABLE:
CURRENT_TEST: perfschema.dml_file_instances
|
--- /mariadb/10.2/mysql-test/suite/perfschema/r/dml_file_instances.result 2018-02-02 15:33:07.860674614 +0200
|
+++ /mariadb/10.2/mysql-test/suite/perfschema/r/dml_file_instances.reject 2018-02-02 15:34:30.639546478 +0200
|
@@ -35,45 +35,53 @@
|
RENAME TABLE t_db_26152751 to t_db_26152751_new;
|
SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
|
FILE_NAME
|
-t_db_26152751_new.frm
|
-t_db_26152751_new.MYI
|
-t_db_26152751_new.MYD
|
+t_db_26152751.frm
|
+t_db_26152751.MYI
|
+t_db_26152751.MYD
|
…
|
This is with the test and result change ported from the above fix. Note that you will also need
diff --git a/mysql-test/suite/perfschema/t/dml_file_instances.test b/mysql-test/suite/perfschema/t/dml_file_instances.test
|
index f95f74fd61a..ea3bf0a1917 100644
|
--- a/mysql-test/suite/perfschema/t/dml_file_instances.test
|
+++ b/mysql-test/suite/perfschema/t/dml_file_instances.test
|
@@ -2,6 +2,7 @@
|
|
--source include/not_embedded.inc
|
--source include/have_perfschema.inc
|
+--source include/have_innodb.inc
|
|
--disable_result_log
|
select * from performance_schema.file_instances limit 1;
|
because InnoDB is not enabled by default in MariaDB.
|