Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8308 Implement SQL standard Common Table Expression (CTE) support
  3. MDEV-8789

Implement non-recursive common table expressions

Details

    Description

      Support for WITH:
      This allows you to refer to a sub query as a table.

      Example:
      with t as (select a from t1 where b >= 'c')
      select * from t2,t where t2.c=t.a

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-5535 cannot reopen temporary table

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Github pull request

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia added a comment -

            while working on this, it was discovered that MDEV-3944 can be trivially fixed.
            Decided to make a separate patch for MDEV-3944 and submit it for testing.

            psergei Sergei Petrunia added a comment - while working on this, it was discovered that MDEV-3944 can be trivially fixed. Decided to make a separate patch for MDEV-3944 and submit it for testing.
            igor Igor Babaev (Inactive) added a comment -

            The contribution was merged with 10.2 and pushed into the 10.2 tree.

            igor Igor Babaev (Inactive) added a comment - The contribution was merged with 10.2 and pushed into the 10.2 tree.

            People

              igor Igor Babaev (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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