[jira] [Created] (GEODE-9632) Wrong output for the range query with wildcard character

["Mario Kevo (Jira)" <ji...@apache.org>]

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)