• Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We currently do not support geo queries for CBR.

      For samplingCE: seems we can trivially synthesize & evaluate a MatchExpression

      Also delete the corresponding comment from the cardinality estimator. It will be outdated after this ticket.

      Note that geo queries do not have an explicit ixscan in their plan, so that was dead code anyway:

      db.a.drop()
      db.a.createIndex({dist: "2d", a: 1})
      db.a.explain().aggregate([{$geoNear: {distanceField: "dist", near: [0, 0]}}, {$count: "cnt"}]).stages[0].$geoNearCursor.queryPlanner.winningPlan

      Prints:

      {
        isCached: false,
        stage: 'GEO_NEAR_2D',
        nss: 'test.a',
        keyPattern: { dist: '2d', a: 1 },
        indexName: 'dist_2d_a_1',
        indexVersion: 2
      }

            Assignee:
            Unassigned
            Reporter:
            Kartal Kaan Bozdogan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: