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;