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

Support lateral derived tables

    XMLWordPrintable

Details

    Description

      Currently MariaDB does not allow to use lateral derived tables in queries though it
      uses builds them internally for when employing split optimization.
      Consider the following query

      SELECT t.b FROM t1, LATERAL (SELECT * FROM t2 WHERE t1.a=t2.a) AS t

      Here the reference t1.a in the WHERE condition of derived table t refers to the field a
      of the table t1 used in the same FROM list as t.

      SQL standard allows lateral derived tables and MySQL 8.0 supports them.

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-6373 Add support for LATERAL keyword

          • Major - Major loss of function.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-26831 New name resolution

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19337 CTEs not working with outer references

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30744 WITH AS clause doesn't work with an outside column

          • Major - Major loss of function.
          • Closed

          Activity

            People

              monty Michael Widenius
              igor Igor Babaev
              Votes:
              41 Vote for this issue
              Watchers:
              36 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.