Lines Matching refs:recursive

364 } {1 {multiple recursive references: t}}
375 # Compute the mandelbrot set using a recursive query
418 # Solve a sudoku puzzle using a recursive query
456 # Some tests that use LIMIT and OFFSET in the definition of recursive CTEs.
488 # Test the ORDER BY clause on recursive tables.
701 # Test cases to illustrate on the ORDER BY clause on a recursive query can be
789 # Without an ORDER BY clause, the recursive query should use a FIFO,
831 # Column wildcards on the LHS of a recursive table expression
860 # 2015-07-05:  Do not allow aggregate recursive queries
866 } {1 {recursive aggregate queries not supported}}
868 # Or window-function recursive queries. Ticket e8275b41.
875   } {1 {cannot use window functions in recursive queries}}
886   } {1 {cannot use window functions in recursive queries}}
1181 # DISTINCT cannot be ignored in a UNION ALL recursive CTE