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


1
2
3
4
5
6
7
8
9

PRAGMA YqlSelect = 'force';

WITH RECURSIVE counter AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1 AS n FROM counter
    WHERE n < 5
)
SELECT * FROM counter;