Details
-
Bug
-
Resolution: Done
-
Critical
-
3.1.3.Final
-
None
Description
I have the test case that can demonstrate it, to be attached in a pull request. Since Doc IDs are assigned at random, the test case tries to cause the bug to happen by creating enough documents to trigger the bug.
Things work just fine if the limit is set to > 1.
The root cause is the query hint isExists being pushed down to the LHS and RHS of JOINs.