You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "Mario Kevo (Jira)" <ji...@apache.org> on 2022/06/02 09:36:00 UTC
[jira] [Resolved] (GEODE-10317) Range query with wildcard character doing wrong comparison
[ https://issues.apache.org/jira/browse/GEODE-10317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mario Kevo resolved GEODE-10317.
--------------------------------
Resolution: Not A Problem
The issue is not in the comparison.
If we changed as it is agreed on the dev list, it will give us the wrong result.
> 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
> Assignee: Mario Kevo
> Priority: Major
> Labels: pull-request-available
>
> 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)