[SERVER-45233] Indexed inequalities to arrays return incorrect results Created: 18/Dec/19 Updated: 29/Oct/23 Resolved: 19/Feb/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 4.2.2, 4.0.14 |
| Fix Version/s: | 4.3.4, 4.2.9, 4.0.21 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ian Boros | Assignee: | Ted Tuckman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | afz, qopt-team | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||||||
| Backwards Compatibility: | Major Change | ||||||||||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||||||||||
| Backport Requested: |
v4.2, v4.0, v3.6
|
||||||||||||||||||||||||||||
| Sprint: | Query 2020-01-27, Query 2020-02-10, Query 2020-02-24 | ||||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||||
| Linked BF Score: | 17 | ||||||||||||||||||||||||||||
| Description |
The bounds we build for this look wrong:
It only includes arrays! Since we index arrays element-wise, this will miss results. |
| Comments |
| Comment by Githook User [ 14/Aug/20 ] |
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: (cherry picked from commit 0630338fb592b3283240ba72ac4b0c7111f6193c) |
| Comment by Githook User [ 14/Aug/20 ] |
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: create mode 100644 jstests/core/array_comparison_correctness.js (cherry picked from commit 52e7950cae37ef3783b05840c04abbbe383fa1ff) |
| Comment by Githook User [ 15/Jul/20 ] |
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: (cherry picked from commit 0630338fb592b3283240ba72ac4b0c7111f6193c) |
| Comment by Githook User [ 15/Jul/20 ] |
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: create mode 100644 jstests/core/array_comparison_correctness.js (cherry picked from commit 52e7950cae37ef3783b05840c04abbbe383fa1ff) |
| Comment by Ted Tuckman [ 19/Feb/20 ] |
|
This changes query results on a multikey index. Where before query results would be wrong and missing most documents from the query without the index, the index should now report the same documents. |
| Comment by Githook User [ 19/Feb/20 ] |
|
Author: {'name': 'Ted Tuckman', 'username': 'TedTuckman', 'email': 'ted.tuckman@mongodb.com'}Message: |
| Comment by Githook User [ 04/Feb/20 ] |
|
Author: {'username': 'TedTuckman', 'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com'}Message: create mode 100644 jstests/core/array_comparison_correctness.js |
| Comment by Githook User [ 04/Feb/20 ] |
|
Author: {'name': 'Ted Tuckman', 'username': 'TedTuckman', 'email': 'TedTuckman@users.noreply.github.com'}Message: |
| Comment by Ian Boros [ 18/Dec/19 ] |
|
charlie.swanson Jacob and I were discussing |
| Comment by Charlie Swanson [ 18/Dec/19 ] |
|
ian.boros how did you notice this? jacob.evans this seems related to or at least in the same area as |