blob: d2c9a74cffac9c106d57940bf1ccdfd64d6ef6fb (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
/* custom error: Recursive query does not have the form non-recursive-term UNION [ALL] recursive-term */
PRAGMA YqlSelect = 'force';
WITH RECURSIVE multi_anchor AS (
SELECT 10 AS val
UNION ALL
SELECT 20 AS val
UNION ALL
SELECT val + 1 AS val FROM multi_anchor WHERE val IN (10, 20)
)
SELECT * FROM multi_anchor ORDER BY val;
|
