[
https://issues.apache.org/jira/browse/GEODE-9632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mario Kevo reassigned GEODE-9632:
---------------------------------
Assignee: Mario Kevo
> 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
> Assignee: Mario Kevo
> Priority: Major
>
> 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)
