Loading...

XML

Word

Printable

JSON

Details

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

Description

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.

Attachments

Issue Links

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 documented by

DOCS-14281 Investigate changes in SERVER-25023: no way to index the same fields with two different partial index filters

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

(1 is related to, 4 related to)

Activity

People

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

Dates

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