Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Done
Priority: Major - P3
Fix Version/s: 4.7.0
Affects Version/s: None
Component/s: Querying
Labels:
- query-44-grooming
- storch

Backwards Compatibility:
Fully Compatible
Sprint:
Query 2020-03-09, Query 2020-03-23, Query 2020-04-06, Query 2020-04-20, Query 2020-05-04
Case:
Linked BF Score:
48
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

If I have a large data set, I might want to create several indexes on it, each index covering only a subset of the full set of documents. Currently that's not allowed because we don't allow same pattern with different options, and filter is part of the options.

causes

PYTHON-2215 Test failure - test_collection.TestCollection.test_index_filter

Closed

SERVER-52814 queryPlanner.winningPlan.inputStage is undefined for a specific query

Closed

is duplicated by

SERVER-32733 Support same index definition but with different partial filter expressions

Closed

SERVER-34841 Cannot create multiple indexes with the same pattern but different options

Closed

is related to

SERVER-24239 Add support for building indices with the same key pattern but different collations

Closed

related to

SERVER-62636 setFeatureCompatibilityVersion 4.4 succeeds on 5.0 binVersion that has indexes with conflicting options

Closed

SERVER-47657 Add 'unique' and 'sparse' parameters to index signature

Closed

SERVER-47659 Add 'wildcardProjection' parameter to index signature

Closed

SERVER-67446 Ensure consistent wildcardProjection and columnstoreProjection specs in catalog

Closed

(4 related to)

Assignee:: Bernard Gorman
Reporter:: Asya Kamsky
Participants:: Asya Kamsky, Bernard Gorman, Coen Smid, Githook User, João Ferreira, Max Hirschhorn, Michael de Hoog, Ramon Fernandez Marina
Votes:: 13 Vote for this issue
Watchers:: 31 Start watching this issue

Created:: Jul 13 2016 12:08:40 AM UTC
Updated:: Jun 22 2022 04:16:35 PM UTC
Resolved:: Apr 26 2020 01:12:00 PM UTC
Confidence Status Last Update:: 26/Feb/20 4:28 PM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates