[MCOL-4230] Insert on VIEW is currently not supported Created: 2020-08-05  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: susil.behera Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
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.
Generated at Thu Feb 08 02:48:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.