You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladislav Pyatkov (Jira)" <ji...@apache.org> on 2026/09/08 15:46:00 UTC

[jira] [Created] (IGNITE-29043) Calcite: Support recursive CTEs without the RECURSIVE keyword

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)