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.
|