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

Recursive CTE must properly respect parenthesis

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Optimizer - CTE
    • Labels:
      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

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

              Dates

              Created:
              Updated:

                Git Integration