A sparse index is not used on mixed sparse-compatible/incompatible predicates

XMLWordPrintableJSON

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

      When a query contains multiple predicates on the same field where some are sparse index compatible and others are not, the query planner performs a issues a collection scan plan instead of an index scan plan on the sparse index for the compatible predicates and applying incompatible predicates as filters.

      This is caused by incorrect overriding of the sparse index compatibility info in QueryPlannerIXSelect::getFields The fix is never override supportSparse = true by supportSparse = False.

            Assignee:
            Unassigned
            Reporter:
            Alexander Ignatyev
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: