Mario Kevo created GEODE-10353:
----------------------------------
Summary: 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
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)
