Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-79599

Geospatial Query Error on MongoDB Version 6.3.2

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.1.0-rc0, 7.0.2
    • Affects Version/s: 6.3.2
    • Component/s: None
    • None
    • Query Integration
    • Fully Compatible
    • ALL
    • v7.0
    • Hide

      Use sample_geospatial.shipwrecks collection and perform attach query operation on the sample data.  

      Show
      Use sample_geospatial.shipwrecks collection and perform attach query operation on the sample data.  
    • QI 2023-08-07, QI 2023-08-21

      We have encountered an issue while executing geospatial queries on MongoDB version 6.3.2. The error message "Union requires two index intervals" is being thrown, and this seems to be specific to instances running MongoDB 6.3.2 with a 2D sphere index created. It's important to note that this error does not occur when the query performs a COLLSCAN operation.

      Furthermore, we have identified that the issue arises when the query involves a compound operation of geospatial and other equality operations. However, if we remove the non-geospatial condition from the query, it executes successfully without any errors.

      The problem is observed on both Atlas serverless and dedicated instances running MongoDB version 6.3.2. Notably, we have verified that this error is not present in MongoDB versions 6.0.8 and 5.0.19.

        1. test_query.js
          2 kB
          APURV VINUBHAI BRAHMBHATT

            Assignee:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Reporter:
            apurv.brahmbhatt@mongodb.com APURV VINUBHAI BRAHMBHATT
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: