Mario Kevo created GEODE-9281:
---------------------------------
Summary: No results for the query with multiple indexes used
Key: GEODE-9281
URL: https://issues.apache.org/jira/browse/GEODE-9281
Project: Geode
Issue Type: Bug
Components: querying
Reporter: Mario Kevo
While running a basic query which is using 2 indexes, there are no results
displayed.
{code:java}
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){code}
While using just one index it works correctly.
{code:java}
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){code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
