[DOCS-3995] Query for NULL values on sparse indexes Created: 04/Sep/14  Updated: 16/Mar/15  Resolved: 22/Sep/14

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: v1.3.11

Type: Improvement Priority: Major - P3
Reporter: James Wahlin Assignee: Andrew Aldridge
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Participants:
Days since reply: 9 years, 21 weeks, 2 days ago

 Description   

The following pages discuss mongod behavior when searching on null values and sparse index behavior. We are missing the cross over between the two.

The "How do I query for fields that have null values? FAQ" should mention behavior when a sparse index is involved as it is an exception to what we have written. When searching for a null value on sparse index you will not get back documents that are missing that field completely.

The sparse index page mentions that it only includes documents where the given field exists. It may be worth mentioning as well that a find() on a null value against a sparse index will not return documents where the field does not exist - contrary to the behavior when a non-sparse index is used.



 Comments   
Comment by Githook User [ 22/Sep/14 ]

Author:

{u'username': u'i80and', u'name': u'Andrew Aldridge', u'email': u'i80and@foxquill.com'}

Message: DOCS-3995: Explain how sparse indexes interact with null queries.

Signed-off-by: kay <kay.kim@10gen.com>
Branch: v2.4
https://github.com/mongodb/docs/commit/eac19daef4b9ab03d404c36d95a0e551d9467410

Comment by Githook User [ 22/Sep/14 ]

Author:

{u'username': u'i80and', u'name': u'Andrew Aldridge', u'email': u'i80and@foxquill.com'}

Message: DOCS-3995: Explain how sparse indexes interact with null queries.

Signed-off-by: kay <kay.kim@10gen.com>
Branch: master
https://github.com/mongodb/docs/commit/235976740a464070b32e44a0fdfa16fb2d1772e3

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