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

Incoherent result subqueries & materialization switch

Details

    Description

      Create a db from the attached dump file, the following select gives a wrong result

      MariaDB [jira]> select fkey from t1 where fkey in (select distinct f4 from t2 where f1=147 and f5='S') order by fkey;
      ------

      fkey

      ------

      267
      267
      267
      267
      267
      267
      267
      267
      267

      ------

      If I switch off materialization adding the following line to the my.cnf file

      optimizer_switch='materialization=off'

      the result is correct

      ------

      fkey

      ------

      90
      93
      261
      262
      263
      264
      265
      266
      267

      ------

      Thanks

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          robertoghidini Roberto Ghidini created issue -
          alice Alice Sherepa added a comment -

          Thanks for the report!
          The problem was fixed by the commit dcbf2823c7d64380f06372 in scope of bug MDEV-13994.

          alice Alice Sherepa added a comment - Thanks for the report! The problem was fixed by the commit dcbf2823c7d64380f06372 in scope of bug MDEV-13994 .
          alice Alice Sherepa made changes -
          Field Original Value New Value
          Fix Version/s 10.2.11 [ 22634 ]
          alice Alice Sherepa made changes -
          issue.field.resolutiondate 2017-11-16 11:37:30.0 2017-11-16 11:37:30.481
          alice Alice Sherepa made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          alice Alice Sherepa made changes -
          Comment [ fixed by the commit dcbf2823c7d64380f06372 in scope of bug MDEV-13994. ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 83848 ] MariaDB v4 [ 153199 ]

          People

            Unassigned Unassigned
            robertoghidini Roberto Ghidini
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.