bugs.gh_9063_test. Incorrect results for DISTINCT used together with IN/EXISTS which is converted into a semi-join