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

CONNECT ODBC Bug: Engine Converts LEFT JOIN into INNER JOIN

    XMLWordPrintable

Details

    Description

      I just realized about a bug, I do not know if it is because of the CONNECT ODBC Engine or MariaDB Server itself:

      When I do a query such as:

      SELECT
           *
      FROM
           t_name_Local_Server AS A
           LEFT JOIN t_Name_Remote_Server AS B
                ON A.Join_Column_Name = B.Join_Column_Name
      

      MariaDB returns a Result Set which performs an INNER JOIN, not a LEFT JOIN. That is, it returns a result set which contains only those rows which are not null in Table aliased as B (t_Name_Remote_Server).

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            Juan Juan Telleria
            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.