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

Unexpected behaviour of FULL JOIN

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 11.0.2
    • N/A
    • OTHER
    • None
    • Docker under Debian

    Description

      The option FULL JOIN works as an INNER JOIN. This is missleading, because you expect the result of a FULL OUTER JOIN or an error message.
      RIGHT OUTER JOIN -> Ok
      RIGHT JOIN -> Ok
      LEFT OUTER JOIN -> Ok
      LEFT JOIN -> Ok
      FULL OUTER JOIN -> Ok, error message
      FULL JOIN -> Not Ok, like INNER JOIN
      MySQL Community Server 8.0.33 has the same missleading behaviour.

      Attachments

        Activity

          People

            Unassigned Unassigned
            adamsralf Ralf Adams
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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