blob: 810682e1b49a6c1702db332aae4d345961e3baf9 [file] [log] [blame]
--! qt:dataset:src
-- Tests that selecting from a view and another view that selects from that same view
CREATE VIEW test_view1 AS SELECT * FROM src;
CREATE VIEW test_view2 AS SELECT * FROM test_view1;
SELECT COUNT(*) FROM test_view1 a JOIN test_view2 b ON a.key = b.key;