[DOCS-7652] geo and text indexes are always sparse (not merely 'default' to sparse) Created: 15/Apr/16  Updated: 30/Oct/23  Resolved: 07/Feb/18

Status: Closed
Project: Documentation
Component/s: Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Improvement Priority: Major - P3
Reporter: Andrew Ryder (Inactive) Assignee: Kay Kim (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-13808 Index option "sparse" should be disal... Backlog
Participants:
Days since reply: 6 years, 1 week ago

 Description   

RE:
https://docs.mongodb.org/manual/core/index-text/#sparse-property
https://docs.mongodb.org/manual/core/2dsphere/#sparse-property
https://docs.mongodb.org/manual/core/2d/#sparse-property

[2d/2dsphere/text] indexes are sparse by default and ignores the sparse: true option.

They also ignore explicitly specifying "sparse:false". The statement should be clarified in these 3 locations to be just "are always sparse and ignore the sparse option".

Somewhat counter-intuitively, specifying "sparse:false" makes the index definition retain it and even print it back on request, clearly showing the "sparse:false" option but it is ignored; SERVER-13808.

These indexes are always sparse no matter what options are passed in.



 Comments   
Comment by Githook User [ 07/Feb/18 ]

Author:

{'email': 'kay.kim@10gen.com', 'name': 'kay', 'username': 'kay-kim'}

Message: DOCS-10587, DOCS-7089, DOCS-7652: highlight v3 of 2dsphere index, clarify sparse property and collation restriction for text/2d/geosphere indexes
Branch: v3.4
https://github.com/mongodb/docs/commit/51c100ae8bccaec0853737fd48526a61585e837b

Comment by Githook User [ 07/Feb/18 ]

Author:

{'email': 'kay.kim@10gen.com', 'name': 'kay', 'username': 'kay-kim'}

Message: DOCS-10587, DOCS-7089, DOCS-7652: highlight v3 of 2dsphere index, clarify sparse property and collation restriction for text/2d/geosphere indexes
Branch: master
https://github.com/mongodb/docs/commit/d9d0572bb9e09ee4bd4cdb6fd3b609ad33ba74d8

Comment by Stennie Steneker (Inactive) [ 09/May/16 ]

This is generally true, aside from the 2dsphere V1 indexes created in MongoDB 2.4 which are not sparse (SERVER-9639). 2dsphere V1 indexes also ignore the sparse option (as per SERVER-13808), so the value of the sparse option currently has no relevance (if set) for 2dsphere index sparseness behaviour.

Generated at Thu Feb 08 07:54:43 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.