yql/essentials/tests/sql/suites/select_yql/with_cte_shadow.yql


1
2
3
4
5
6
7
8
9
10
11
12
13

PRAGMA YqlSelect = 'force';

WITH
    x AS (
        SELECT 111 AS a
    ),
    y AS (
        WITH x AS (
            SELECT 0 + 1 AS a
        )
        SELECT a + 1 AS a FROM x
    )
SELECT a + 1 AS a FROM y;