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

Add Aria table for Engine Merge

    XMLWordPrintable

Details

    Description

      To reproduce , the testcase from
      https://mariadb.com/kb/en/library/merge/
      is valid, only changed engine to aria.

      CREATE TABLE t1 (
          a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
          message CHAR(20)) ENGINE=Aria;
       
      CREATE TABLE t2 (
          a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
          message CHAR(20)) ENGINE=Aria;
       
       
      INSERT INTO t1 (message) VALUES ('Testing'),('table'),('t1');
       
      INSERT INTO t2 (message) VALUES ('Testing'),('table'),('t2');
       
      CREATE TABLE total (
          a INT NOT NULL AUTO_INCREMENT,
          message CHAR(20), INDEX(a))
          ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;
       
      SELECT * FROM total;
      

      Result:

      MariaDB [test]> SELECT * FROM total;
      ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
      

      But regarding Aria FAQ, it should work:

      The same core MySQL engineers who developed the MySQL server and the MyISAM, MERGE, and MEMORY storage engines are also working on Aria.

      https://mariadb.com/kb/en/library/aria-faq/

      Attachments

        Issue Links

          Activity

            People

              julien.fritsch Julien Fritsch
              Richard Richard Stracke
              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.