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


1
2
3
4
5
6
7
8
9

PRAGMA YqlSelect = 'force';

WITH RECURSIVE fibonacci AS (
    SELECT 0 AS a, 1 AS b
    UNION ALL
    SELECT b AS a, a + b AS b FROM fibonacci
    WHERE b < 10
)
SELECT a FROM fibonacci;