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

Correlated derived tables not supported

    XMLWordPrintable

    Details

      Description

      The following query is currently not possible in MariaDB:

      CREATE TABLE t (x int);
       
      SELECT (
        SELECT u.x
        FROM (
          SELECT t.x
        ) u
      )
      FROM t;
      

      The error I'm getting is:

      SQL Error [1109] [42S02]: (conn:9) Unknown table 't' in field list
      

      Most RDBMS, including recent versions of MySQL 8 now support correlating derived tables like that. It's an essential feature for more sophisticated queries.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              lukas.eder Lukas Eder
              Votes:
              1 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.