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

Joining CTEs inside a function fails with error code 1146 despite the tables existing

    XMLWordPrintable

Details

    Description

      When I wrap a statement containing two or more Common Table Expressions in a function, and one of those CTEs is JOINed to another CTE, executing the function will result in error code 1146, reporting that the first table that the CTE interacts with doesn't exist - even though it does.

      Extracting the failing query and running it standalone works fine, the query will return the expected results.

      I have attached sample SQL that replicates this behaviour.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Jon Kilgallon Jon Kilgallon
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.