[GEODE-9281] No results for the query with multiple indexes used

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: querying
• Labels: pull-request-available
• Assignee: Mario Kevo
• Reporter: Mario Kevo
• Created: 17/May/21 06:42
• Updated: 22/Jun/22 20:45
• Resolved: 25/May/21 06:36

Description

While running a basic query which is using 2 indexes, there are no results displayed.

gfsh>query --query="<trace>SELECT value FROM /example-region.entrySet WHERE value.ExpiredTime >= 0 AND value.ExpiredTime < 1719592199000L AND (value.status = 'SUSPENDED' or value.status = 'REGISTERED')"
Result : true
Limit : 100
Rows : 0
Query Trace : Query Executed in 29.131016 ms; indexesUsed(2):ExpiredTimeIndex(Results: 500),StatusIndex(Results: 250)

 While using just one index it works correctly.

gfsh>query --query="<trace>SELECT value FROM /example-region.entrySet WHERE value.ExpiredTime >= 0 AND value.ExpiredTime < 1719592199000L"
Result : true
Limit : 100
Rows : 100
Query Trace : Query Executed in 15.422983 ms; indexesUsed(1):ExpiredTimeIndex(Results: 500)

 

Steps to reproduce the issue:

1. start locator --name=locator1
2. configure pdx --read-serialized=true --disk-store
3. start server --name=server1 --server-port=0
4. start server --name=server2 --server-port=0
5. create region --name=example-region --type=PARTITION_PERSISTENT --redundant-copies=1
6. put entries
7. create index --name=ExpiredTimeIndex --expression=value.ExpiredTime --region="/example-region.entrySet" --type=range
8. create index --name=StatusIndex --expression=value.Status --region="/example-region.entrySet" --type=range
9. query --query="<trace>SELECT value FROM /example-region.entrySet WHERE value.ExpiredTime >= 0 AND value.ExpiredTime < 1719592199000L AND (value.Status = 'SUSPENDED' or value.Status = 'REGISTERED')"

 

Issue Links

• links to: GitHub Pull Request #6485