Mario Kevo created GEODE-9632:
---------------------------------
Summary: Wrong output for the range query with wildcard character
Key: GEODE-9632
URL: https://issues.apache.org/jira/browse/GEODE-9632
Project: Geode
Issue Type: Bug
Components: querying
Reporter: Mario Kevo
We are using a range index on an attribute that is defined as HashMap.
The problem is when we are using wildcard characters the Results field in
QueryTrace is 100, but should be 0 as there is no attribute with that value or
something similar.
There is an example:
{code:java}
gfsh>query --query="<trace>SELECT e.key, e.value from /example-region.entrySet
e where e.value.positions['SUN'] LIKE '342234525745'"
Result : true
Limit : 100
Rows : 1
Query Trace : Query Executed in 8.95536 ms; indexesUsed(1):index1(Results: 1)
gfsh>query --query="<trace>SELECT e.key, e.value from /example-region.entrySet
e where e.value.positions['SUN'] LIKE 'something%'"
Result : true
Limit : 100
Rows : 0
Query Trace : Query Executed in 17.171972 ms; indexesUsed(1):index1(Results:
100)
{code}
{color:#1d1c1d}When we are using it without range index we got this:{color}
{code:java}
gfsh>query --query="<trace>SELECT e.key, e.value from /example-region.entrySet
e where e.value.positions['SUN'] LIKE 'something%'"
Result : true
Limit : 100
Rows : 0
Query Trace : Query Executed in 14049.559 ms; indexesUsed(0){code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
