Details
-
Type:
New Feature
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: Icebox
-
Component/s: DMLProc
-
Labels:None
-
Environment:Server version: 10.5.5-MariaDB MariaDB Server
Columnstore: 1.5.4-1
Description
Like other storage engines Columnstore should also support INSERT on views.
CREATE TABLE t1 (x INT)ENGINE=Columnstore;
INSERT INTO t1 VALUES (5), (8), (10), (20), (30);
CREATE VIEW v1 AS SELECT x FROM t1 where x>10;
INSERT INTO v1 VALUES(1);
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported.