Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15179

performance_schema.file_instances does not reflect RENAME TABLE

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.