Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
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.
Attachments
Issue Links
- duplicates
-
MDEV-19242 Add Aria support for MERGE engine.
- Stalled