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

FULL OUTER JOIN get correct sargable condition

    XMLWordPrintable

Details

    • Q1/2026 Server Development, Q1/2026 Server Maintenance, Q2/2026 Server Maintenance, Q2/2026 Server Development, Q3/2026 Server Maintenance

    Description

      Consider

      select * 
      from 
        t1 full outer join t2 on on_cond
      where
        where_cond
      

      Here, we can use on_cond to construct table quick selects. We can't use where_cond with FULL OUTER JOIN.

      get_sargable_cond() implements this logic for LEFT JOIN. Need to modify it for FULL OUTER JOIN.

      Attachments

        Activity

          People

            monty Michael Widenius
            Gosselin Dave Gosselin
            Dave Gosselin Dave Gosselin
            Michael Widenius Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 2d
                2d
                Remaining:
                Time Spent - 1d 3h Remaining Estimate - 5h
                5h
                Logged:
                Time Spent - 1d 3h Remaining Estimate - 5h
                1d 3h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.