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

Unable to recognize/import partitioned tables from physical MySQL databases.

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              juan.vera Juan
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.