DROP VIEW xxx8; | |
DROP VIEW xxx9; | |
-- create two levels of view reference, then invalidate intermediate view | |
-- by dropping a column from underlying table, and verify that | |
-- querying outermost view results in full error context | |
CREATE TABLE xxx10 (key int, value int); | |
CREATE VIEW xxx9 AS SELECT * FROM xxx10; | |
CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx; | |
ALTER TABLE xxx10 REPLACE COLUMNS (key int); | |
SELECT * FROM xxx8 yyy; |