[GEODE-8287] QueryUtils doNestedIterationsForIndex is not applying an index value correctly and causing the entire region to be iterated

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.12.1, 1.13.0, 1.14.0
• Component/s: querying
• Labels: caching-applications
• Assignee: Barrett Oglesby
• Reporter: Barrett Oglesby
• Created: 19/Jun/20 20:35
• Updated: 10/Sep/20 15:52
• Resolved: 25/Jun/20 20:53

Description

Here is an example of the query in 8.2.12:

Query Executed in 3.502438E7 ms; indexesUsed(2):mapFieldIndex(Results: 500),pkIdIndex(Results: 1) "select vr1, vr2 from /region1 vr1, /region2 vr2 where vr1.id = vr2.id and vr1.mapField['FIELDNAME']=$1"

The number of DistributionStats deserializations is 1,001.

Here is an example of the query in 9.10.0:

Query Executed in 22732.467 ms; rowCount = 500; indexesUsed(2):mapFieldIndex(Results: 500),pkIdIndex(Results: 1) "select vr1, vr2 from /region1 vr1, /region2 vr2 where vr1.id = vr2.id and vr1.mapField['FIELDNAME']=$1"

The number of DistributionStats deserializations is 25,001,004

Issue Links

• links to: GitHub Pull Request #5279