[SERVER-54642] Support other index types on the metadata fields in a time-series collection. Created: 19/Feb/21  Updated: 29/Oct/23  Resolved: 19/Mar/21

Status: Closed
Project: Core Server
Component/s: Storage
Affects Version/s: None
Fix Version/s: 4.9.0

Type: Task Priority: Major - P3
Reporter: Benety Goh Assignee: Dianna Hohensee (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
Related
is related to SERVER-54361 Prevent unique index creation on coll... Closed
is related to SERVER-54888 Prohibit partial indexes on time-seri... Closed
is related to SERVER-55233 Support wildcard index type on the me... Closed
is related to SERVER-55239 Support 2dsphere index on time-series... Closed
is related to SERVER-55240 Support 2d index on time-series colle... Closed
Backwards Compatibility: Fully Compatible
Sprint: Execution Team 2021-03-22, Execution Team 2021-04-05
Participants:

 Description   

Additional index types that would be nice to support on the metadata field include:

  • 2dsphere
  • 2d
  • hashed
  • text
  • wildcard
  • sparse
  • multikey
    * indexes with collations.



 Comments   
Comment by Githook User [ 19/Mar/21 ]

Author:

{'name': 'Dianna Hohensee', 'email': 'dianna.hohensee@mongodb.com', 'username': 'DiannaHohensee'}

Message: SERVER-54642 JS testing for sparse, multikey, 2d and 2dsphere indexes on time-series collections.

Note: 2d and 2dsphere indexes are not yet usable via the time-series collection, only on the
underlying buckets collection after creation via the time-series collection.
Branch: master
https://github.com/mongodb/mongo/commit/991e2f2795758260ea3215d0a965ebf91583f971

Comment by Dianna Hohensee (Inactive) [ 16/Mar/21 ]

We are excluding "text" indexes because we don't have view support with text indexes. This is the text index code that only looks at the CollectionCatalog, not the ViewCatalog.

Comment by Dianna Hohensee (Inactive) [ 09/Mar/21 ]

Looks like we will have to convert the index key paths specified in the 'wildcardProjection' field of createIndexes, too.

Generated at Thu Feb 08 05:34:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.