[
https://issues.apache.org/jira/browse/GEODE-8962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Owen Nichols closed GEODE-8962.
-------------------------------
> 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
> Fix For: 1.15.0
>
>
> {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.20.7#820007)
