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

          alice Alice Sherepa added a comment -

          There is no FULL join in MariaDb ( https://mariadb.com/kb/en/join-syntax/ ), so the word FULL was interpreted as an alias for the table- so no error, just inner join. In the second example - FULL OUTER JOIN - again FULL-alias, but then OUTER - it should be LEFT OUTER or RIGHT OUTER , otherwise - sql syntax error.

          alice Alice Sherepa added a comment - There is no FULL join in MariaDb ( https://mariadb.com/kb/en/join-syntax/ ), so the word FULL was interpreted as an alias for the table- so no error, just inner join. In the second example - FULL OUTER JOIN - again FULL-alias, but then OUTER - it should be LEFT OUTER or RIGHT OUTER , otherwise - sql syntax error.
          adamsralf Ralf Adams added a comment -

          Thanks for this quick answer. This explains the behaviour. But I think it is very missleading in this case. It looks like a short version of a FULL OUTER JOIN because OUTER is optional and by not receiving an error message you may think that this is a FULL OUTER JOIN result.

          adamsralf Ralf Adams added a comment - Thanks for this quick answer. This explains the behaviour. But I think it is very missleading in this case. It looks like a short version of a FULL OUTER JOIN because OUTER is optional and by not receiving an error message you may think that this is a FULL OUTER JOIN result.

          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.