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

Selection having joined subselect having a left join produces wrong result in some cases

    XMLWordPrintable

Details

    Description

      Hello,

      we stumbled over a wrong result when using a joined subquery having a left join. The query should have returned an empty result set but instead returns some (wrong) lines. The result depends on how we define the where clause in the subselect. Though just rephrasing identical logic in different ways, the results differ, and only one where-condition returns the correct result (note: the result does not even depend on thate particular where condition). Removing the left join from the subquery resolves the problem, too.

      I prepared a minimal example showing the bug in the attached file. We use the docker container version 10.6 of mariadb, currently it's version 10.6.3

      Attachments

        Activity

          People

            Unassigned Unassigned
            jankoh Jan Kohnert
            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.