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

Wrong results in COUNT() query with EXISTS and exists_to_in

    Details

    • Sprint:
      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

          Activity

            People

            • Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              claudio.nanni Claudio Nanni
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: