[SERVER-83624] Search with $in and $regex returns empty result Created: 28/Nov/23 Updated: 16/Jan/24 Resolved: 16/Jan/24 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 7.0.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Mikhail Lepeshkin | Assignee: | Alison Rhea Thorne |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Operating System: | ALL |
| Steps To Reproduce: | We can reproduce it on our database with 180k records. But I failed to build synthetic test with this case. |
| Participants: |
| Description |
|
We have a collection 'plain_time_series'. The typical documents in this collection looks like this:
The following query returns 0 records, but should return 4:
The other similar queries sometimes returns expected result and sometimes not. Adding {{.limit(<any number>) }}seems to solve the issue. Below you can find the winning query plan.
|
| Comments |
| Comment by Alison Rhea Thorne [ 16/Jan/24 ] |
|
We haven’t heard back from you for some time, so I’m going to close this ticket. If this is still an issue for you, please provide additional information and we will reopen the ticket. |
| Comment by Alison Rhea Thorne [ 03/Jan/24 ] |
|
We still need additional information to diagnose the problem. If this is still an issue for you, would you please provide the following information? 1. More information on the timeseries that this impacts? Notably specifically timeseries configuration and indexes. |
| Comment by Alison Rhea Thorne [ 12/Dec/23 ] |
|
Hello mlepeshkin, In the interest of attempting to replicate and troubleshoot this issue, can you provide the following information: 1. More information on the timeseries that this impacts? Notably specifically timeseries configuration and indexes. Thank you |