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


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

/* FIXME(YQL-20631): recursive reference must not appear within an outer join */
PRAGMA YqlSelect = 'force';

WITH RECURSIVE outer_join AS (
    SELECT 1 AS n
    UNION ALL
    SELECT dummy.val + 1 AS n
    FROM (SELECT 2 AS val) AS dummy
    LEFT JOIN outer_join AS b ON dummy.val = b.n
    WHERE b.n < 5
)
SELECT * FROM outer_join;