Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
This is a split off 4687 (INSERT AS SELECT FROM VIEW).
Remaining problem:
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
- split from
-
MCOL-4687 Insert from view regression
- Closed