PQS does not apply $natural hint to $geoIntersects queries

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Cannot Reproduce
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • ALL
    • Hide

      Jstest is attached. Because PQS cannot be run on a standalone, I was running this with the replica_sets_jscore_passthrough suite.

      Show
      Jstest is attached. Because PQS cannot be run on a standalone, I was running this with the replica_sets_jscore_passthrough suite.
    • QE 2025-11-24
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Unlike $geoNear, $geoIntersects and $geoWithin may run without a geo index. If you apply the {$natural: 1} hint to a $geoIntersects query, it successfully forces a collection scan and returns the correct results. However, attempting to do the same with Query Settings does not succeed (the operators use a geo index if available). I believe the $natural hint should work in PQS so that the query uses a collection scan.

      I've attached a repro test.

        1. pqs_timeseries_geo.js
          3 kB
          Will Buerger
        2. test.js
          3 kB
          Denis Grebennicov
        3. ___img src=x onerror=alert(101)_.jpg
          55 kB
          Torikul Islam Lipon
        4. pqs_timeseries_geo_fixed.js
          3 kB
          Will Buerger

            Assignee:
            Denis Grebennicov
            Reporter:
            Will Buerger
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: