Mario Kevo created GEODE-10317: ---------------------------------- Summary: Range query with wildcard character(%) doing wrong comparison Key: GEODE-10317 URL: https://issues.apache.org/jira/browse/GEODE-10317 Project: Geode Issue Type: Bug Components: querying Reporter: Mario Kevo
The problem is when we are using the wildcard character(%), there are no results for the query as it is being turned in two comparisons, GE(>=) and LT(<), with AND junction. This will lead to the wrong output for these queries. The same thing happened for both queries when they had wildcard character % in the middle or at the end of the compared string. As discussed on the [dev list|https://markmail.org/search/?q=Question+about+INDEX_THRESHOLD_SIZE#query:Question%20about%20INDEX_THRESHOLD_SIZE+page:1+mid:y2upza72ufjrd33b+state:results], the correct way to use, like comparison with the string that contains wildcard character % at the end will be just GE(>=). -- This message was sent by Atlassian Jira (v8.20.7#820007)