You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2021/02/22 19:37:00 UTC
[jira] [Updated] (GEODE-8962) Not possible to escape "$" character
in query using LIKE operator
[ https://issues.apache.org/jira/browse/GEODE-8962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated GEODE-8962:
----------------------------------
Labels: pull-request-available (was: )
> Not possible to escape "$" character in query using LIKE operator
> -----------------------------------------------------------------
>
> Key: GEODE-8962
> URL: https://issues.apache.org/jira/browse/GEODE-8962
> Project: Geode
> Issue Type: Bug
> Components: querying
> Reporter: Mario Kevo
> Assignee: Mario Kevo
> Priority: Major
> Labels: pull-request-available
>
> {color:#000000}If one query tries to match a string containg "$" character by a "=" or a "contains" operation, it works, and if data contains a "$" character and expression of query looks for it, works as expected.{color}
> {color:#172b4d} {color}
>
> {code:java}
> gfsh>query --query="select e.key from /example-region.entrySet e where e.key='aa$b'"
> Result : true
> Limit : 100
> Rows : 1
> Result
> ------
> aa$b{code}
>
>
> {color:#000000}But if we replace the "=" operator in the Geode query by a "LIKE" operator, and a wildcard is added, then it seems the regular expression mode is somehow triggered and the "$" character starts behaving like endline character. That is expected. {color}{color:#172b4d}
> {color}
> {color:#172b4d} {color}
>
> {code:java}
> gfsh>query --query="select e.key from /example-region.entrySet e where e.key like 'aa$b'"
> Result : true
> Limit : 100
> Rows : 0
> {code}
>
>
> {color:#000000}There is no way to escape "$" character.{color}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)