[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. |