[MDEV-18883] Add Aria table for Engine Merge Created: 2019-03-11  Updated: 2020-04-14  Resolved: 2019-03-14

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Storage Engine - Aria
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Julien Fritsch
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-19242 Add Aria support for MERGE engine. Stalled

 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/

 Comments   
Comment by Sergei Golubchik [ 2019-03-14 ]

The manual says, let me add parentheses to make it more clear, " The same core MySQL engineers (who developed the MySQL server and the MyISAM, MERGE, and MEMORY storage engines) are also working on Aria."

It does not say or imply that MERGE engine should work with Aria tables

Generated at Thu Feb 08 08:47:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.