[DOCS-16010] [Server] limitation for wildcard index queries Created: 04/Apr/23  Updated: 30/Oct/23  Resolved: 07/Apr/23

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

Type: Improvement Priority: Critical - P2
Reporter: Janpreet Singh Assignee: Dave Cuthbert (Inactive)
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 44 weeks, 1 day ago

 Description   

Original title: [Server] Need to add a note under "Unsupported Query and Aggregation Patterns" section for wildcard indexes when the indexed field is queried against a null value

Recently we tested that when a wildcard index is created and the indexed field is queried against the `null` value using equality match, it doesn't use the index as this is expected behaviour. The reason is 

Per our documentation on Query for Null or Missing Fields when using the equality filter, it confirms that the query matches documents that either contain the field whose value is null OR that do not contain the field. As such, it confirms that the wildcard index won't be used, as mentioned in the Unsupported Query Patterns that the wildcard indexes cannot support query conditions that check if a field does not exist.

 

Need to mention as a note in the "Unsupported Query and Aggregation Patterns" under "Field does not exist" section about this expected behaviour detected



 Comments   
Comment by Sarah Olson [ 04/Apr/23 ]

Increasing priority and triaging to Ready for Work based on the associted customer case. 

Generated at Thu Feb 08 08:14:22 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.