You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I searched the issues and found no similar issues.
What Happened
CONNECT BY syntax is valid in Snowflake and is not currently supported in sqlfluff.
Expected Behaviour
The CONNECT BY construct should be parseable.
Observed Behaviour
When using CONNECT BY sqlfluff returns
Found unparsable section: 'connect by prior foo = bar'
and
WARNING: Parsing errors found and dialect is set to 'snowflake'. Have you configured your dialect correctly?
How to reproduce
with tbl as (
select'A'as foo, 'B'as bar
union allselect'B'as foo, 'C'as bar
)
select*,
connect_by_root bar as connect_by_root
from tbl
connect by prior foo = bar
Search before asking
What Happened
CONNECT BY
syntax is valid in Snowflake and is not currently supported in sqlfluff.Expected Behaviour
The
CONNECT BY
construct should be parseable.Observed Behaviour
When using
CONNECT BY
sqlfluff returnsand
How to reproduce
Dialect
Version
Configuration
.sqlfluff
Are you willing to work on and submit a PR to address the issue?
Code of Conduct
The text was updated successfully, but these errors were encountered: