Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
5.6.1
-
None
Description
The reported issue is from MCOL-4687. Please refer to that ticket for additional details.
UPDATE and DELETE also do not work:
DROP TABLE IF EXISTS t1,t2;
|
DROP VIEW IF EXISTS v1;
|
CREATE TABLE t1 (id INT, fname VARCHAR(20)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1,'Greg');
|
CREATE VIEW v1 as SELECT * FROM t1;
|
SELECT * FROM v1;
|
CREATE TABLE t2 (id INT, fname VARCHAR(20)) ENGINE=Columnstore;
|
INSERT INTO t2 VALUES (1,'Roman');
|
UPDATE t2,v1 SET t2.fname=v1.fname WHERE t2.id=v1.id;
|
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1011: Update on VIEW is currently not supported.
|
DELETE t2 FROM t2,v1 WHERE t2.id=v1.id;
|
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1011: Delete on VIEW is currently not supported.
|
Attachments
Issue Links
- relates to
-
MCOL-4687 Insert from view regression
- Closed