[
https://issues.apache.org/jira/browse/GEODE-10353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mario Kevo reassigned GEODE-10353:
----------------------------------
Assignee: Mario Kevo
> Change IndexThresholdSize default value
> ---------------------------------------
>
> Key: GEODE-10353
> URL: https://issues.apache.org/jira/browse/GEODE-10353
> Project: Geode
> Issue Type: Bug
> Components: querying
> Reporter: Mario Kevo
> Assignee: Mario Kevo
> Priority: Major
> Labels: needsTriage
>
> When doing range queries with the wildcard character(%), there are no result.
> The problem is that when we are doing a range query like this:
> {code:java}
> query --query="<trace>SELECT e.key, e.value from /example-region.entrySet e
> where e.value.positions['SUN'] LIKE 'abc%'"
> {code}
> The printed results will be null.
> The comparison will be divided into two comparison >='abc' and <'abd'.
> First it checks all entries that are lower than 'abd' and store them in the
> intermediate results. There are all entries which attribute 'SUN' is lower
> than 'abd' which can be a very high number. It iterates through all entries
> and store first 100 entries in the intermediate results. The limit is 100, it
> can be changed if an user sets the indexThresholdSize to higher value when
> starting servers, but in many cases the user couldn't know how many entries
> will be in the region.
> So the best way is to set this indexThresholdSize to Integer.MAX_VALUE by
> default so the query will always give the correct results.
> The limit which is set in query is not the same as this limit, so with this
> change it will still put limit on printing results.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
