[jira] [Closed] (GEODE-8962) Not possible to escape "$" character in query using LIKE operator

["Owen Nichols (Jira)" <ji...@apache.org>]

     [ 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)