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

WITH RECURSIVE supports CYCLE clause, but it is not documented

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • N/A
    • N/A
    • Documentation
    • None

    Description

      The KB page for common table expressions syntax doesn't mention the CYCLE clause anywhere (except for an unaswered user's question). In fact, it appears to be supported, there is even an MTR test for it, main/cte_cycle.test.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-20632 Recursive CTE cycle detection using CYCLE clause (nonstandard)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Ian Gilfillan made transition -
            Open Closed
            		84d 23h 20m 1

            People

              greenman Ian Gilfillan
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.