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

Wrong results in COUNT() query with EXISTS and exists_to_in

    XMLWordPrintable

Details

    • 10.2.10, 5.5.58, 10.1.29, 10.1.30, 10.2.12, 5.5.59

    Description

      A COUNT() query containing EXISTS and subqueries returns wrong results.
      Sometimes disabling the optimizer switch exists_to_in works as expected, I can't always reproduce this behaviour thou.
      Dropping an index (see sample.txt) also seems to fix, but there it's still 1 row off: 468 vs 469)

      Attachments

        1. sample.txt
          5 kB
          Claudio Nanni
        2. test_case_scr.sql
          486 kB
          Claudio Nanni

        Activity

          People

            sanja Oleksandr Byelkin
            claudio.nanni Claudio Nanni
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.