Inverted predicates with inexact index bounds fail under histogramCE

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Critical - P2
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Steps to reproduce:

      db.adminCommand({setParameter: 1, planRankerMode: "automaticCE"}) // Or histogramCE
      db.a.drop()
      db.a.insertOne({})
      db.a.find({_id: {$not: {$regex: /test/}}})
      

      You get:

      Cannot invert inexact bounds 

      Stack trace (for a similar query) is attached.

      This blocks SERVER-117209 because the smoke_tests/catalogand_routing:no_passthrough tests runs with all feature flags, thus with CBR enabled, and run into this bug.

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

              Created:
              Updated: