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

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            juan.vera Juan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: