yt/yql/tests/sql/suites/pg/yql-21307.sql


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

--!syntax_pg
/* hybridfile can not */
/* dqfile can not */

WITH RECURSIVE
    x AS (SELECT key FROM plato."Input"),
    r AS (
        SELECT key FROM x
        UNION ALL
        SELECT key FROM r WHERE FALSE
    )
SELECT Count(key) FROM r;