Skip to content

DuckDB dialect parse error: Quirks LIMIT #6087

@denis-komarov

Description

@denis-komarov

Fully reproducible code snippet

from sqlglot import parse_one
sql='''SELECT 1 FROM ( SELECT 1 ) t( c ) WHERE ( ( VALUES(1), (c) LIMIT 1 ) INTERSECT ( SELECT 1 ) );'''
parse_one( sql, dialect = 'duckdb' )
Expecting ). Line 1, Col: 64.
  SELECT 1 FROM ( SELECT 1 ) t( c ) WHERE ( ( VALUES(1), (c) LIMIT 1 ) INTERSECT ( SELECT 1 ) );

Official Documentation
LIMIT and OFFSET Clauses

Package Version
sqlglot 27.27.0
sqlglotrs 0.7.3

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions