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

FULL OUTER JOIN get correct sargable condition

    XMLWordPrintable

Details

    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:

              Git Integration

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