Vladislav Pyatkov created IGNITE-29043:
------------------------------------------
Summary: Calcite: Support recursive CTEs without the RECURSIVE
keyword
Key: IGNITE-29043
URL: https://issues.apache.org/jira/browse/IGNITE-29043
Project: Ignite
Issue Type: Improvement
Reporter: Vladislav Pyatkov
Assignee: Vladislav Pyatkov
Allow omitting RECURSIVE by detecting CTE self-references after parsing and
setting the recursive flag before validation. Respect nested CTE scopes and
identifier casing. Although this syntax is not ANSI SQL compliant, it is a
valuable usability improvement that simplifies queries and improves
compatibility with other databases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
