Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
-
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.