Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1865

Queries with LIMIT 1 return no results (when LIMIT >2 do return some)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 3.2.0.Final
    • 3.1.3.Final
    • Query
    • 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.

      Attachments

        Activity

          People

            rhauch Randall Hauch (Inactive)
            clementp_jira Clement Pang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: