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
|
# name: test/sql/cte/test_issue_5673.test
# description: Issue #5673 and #4987: CTE and Table name are name shadowing
# group: [cte]
statement ok
PRAGMA enable_verification
statement ok
create or replace table orders(ordered_at int);
statement ok
create or replace table stg_orders(ordered_at int);
statement ok
insert into orders values (1);
statement ok
insert into stg_orders values (1);
query I
with
orders as (
select * from main.stg_orders
where ordered_at >= (select max(ordered_at) from main.orders)
),
some_more_logic as (
select *
from orders
)
select * from some_more_logic;
----
1
|
