Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19151

Recursive CTE must properly respect parenthesis

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Optimizer - CTE
    • None

    Description

      Now when parenthesis (brackets) is properly supported for query expressions numerous limitations imposed on recursive CTE must be lifted. In particular,

      • mix of UNION and UNION ALL must be allowed
      • INTERSECT and EXCEPT don't have to be wrapped into derived tables.
        At same time the rules of partitioning a recursive CTE specification for non-recursive and recursive part must strictly follow the SQL standard. This partitioning must be ascertained by the top level operation of the CTE specification and this operation must be either UNION or UNION ALL

      Attachments

        Activity

          People

            igor Igor Babaev
            igor Igor Babaev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.