allow $expr with comparison bounded by value and $type to use a non-multikey index

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      For example for the following query, we generate bounds from MinKey to the date specified, rather than restrict bounds to only include BSON type Date.

      db.c.find({$expr: {$and: [{$lt: ["$x", ISODate("2022-09-14T00:00:00Z")]}, {$eq: [{$type: "$x"}, "date"]}]}});

            Assignee:
            Unassigned
            Reporter:
            James Wahlin
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: