[jira] [Updated] (GEODE-10353) Change IndexThresholdSize default value

["Alexander Murmann (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GEODE-10353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Murmann updated GEODE-10353:
--------------------------------------
    Labels: needsTriage  (was: )

> 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
>            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)