1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
# name: test/sql/catalog/view/recursive_view_with_dependencies.test
# description: Issue #3017: Querying View of a View Crashes
# group: [view]
statement ok
set storage_compatibility_version='v1.0.0'
statement ok
set enable_view_dependencies=true
statement ok
CREATE TABLE IF NOT EXISTS test (val INTEGER);
statement ok
INSERT INTO test(val) VALUES (1), (2), (3);
# recursive view definition
statement ok
CREATE OR REPLACE VIEW foo AS (SELECT * FROM test);
statement error
CREATE OR REPLACE VIEW foo AS (SELECT * FROM foo);
----
Catalog Error: CREATE OR REPLACE is not allowed to depend on itself
# more complex recursive view definition
statement ok
CREATE OR REPLACE VIEW foo AS (SELECT * FROM test);
statement ok
CREATE OR REPLACE VIEW foo2 AS (SELECT * FROM foo);
statement error
CREATE OR REPLACE VIEW foo AS (SELECT (SELECT * FROM foo2));
----
Catalog Error: CREATE OR REPLACE is not allowed to depend on itself
|
