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

FULL OUTER JOIN: Convert to LEFT/INNER when possible

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.3
    • Optimizer
    • None
    • Q4/2025 Server Development

    Description

      Taking a part of MDEV-36813:

      Current optimizer converts LEFT JOIN into INNER JOIN based on null-rejecting predicates. This is done in simplify_joins().

      Similarly, one can convert FULL OUTER JOIN into LEFT/RIGHT JOIN based on null-rejecting predicates.

      This is what this MDEV does.

      Attachments

        Issue Links

          split from

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36813 DRAFT: FULL OUTER JOIN for single table

          • Major - Major loss of function.
          • In Progress

          Activity

            People

              Gosselin Dave Gosselin
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: