-
Notifications
You must be signed in to change notification settings - Fork 1.1k
Closed
Description
Fully reproducible code snippet
from sqlglot import parse_one
sql='''WITH RECURSIVE tbl(a, b) USING KEY (a)
AS
(
SELECT a, b
FROM (VALUES (1, 3), (2, 4)) t(a, b)
UNION
SELECT a + 1, b
FROM tbl
WHERE a < 3
)
SELECT *
FROM tbl;'''
parse_one( sql, dialect = 'duckdb' )Expecting (. Line 1, Col: 30.
WITH RECURSIVE tbl(a, b) USING KEY (a)
AS
(
SELECT a, b
FROM (VALUES (1, 3), (2, 4)) t(a, b)
UNION
SELECT a + 1, b
Official Documentation
Recursive CTEs with USING KEY
Package Version
sqlglot 27.25.2
sqlglotrs 0.7.2
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels