Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.13.1, 1.14.0
Description
We are using a range index on an attribute that is defined as HashMap.
The problem is when we are using wildcard character(%), there is no results for the query despite of there are some entries that meet the condition we are checking.
There is an example:
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 9.082156 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 '34223452574%'" Result : true Limit : 100 Rows : 0 Query Trace : Query Executed in 4.677162 ms; indexesUsed(1):index1(Results: 100)
As we are using indexes to have a better performance of executing a query it first need to check how many entries has that field which we are looking for. It stores it in index results and then check how many of them meet condition we defined in our query.
The problem is that there is parameter INDEX_THRESHOLD_SIZE which default value is 100. If there is a lot of entries in the region it will write just first 100 entries that is found.
This parameter can be changed while starting servers by adding -Dgemfire.Query.INDEX_THRESHOLD_SIZE=<value>, but if we set it to a higher value than the limit in the query is, it will overwrite it. So there should be some changes to take this attribute into account.