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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GEODE-8962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288589#comment-17288589 ] 

ASF GitHub Bot commented on GEODE-8962:
---------------------------------------

mkevo opened a new pull request #6044:
URL: https://github.com/apache/geode/pull/6044


   Thank you for submitting a contribution to Apache Geode.
   
   In order to streamline the review of the contribution we ask you
   to ensure the following steps have been taken:
   
   ### For all changes:
   - [x] Is there a JIRA ticket associated with this PR? Is it referenced in the commit message?
   
   - [x] Has your PR been rebased against the latest commit within the target branch (typically `develop`)?
   
   - [x] Is your initial contribution a single, squashed commit?
   
   - [x] Does `gradlew build` run cleanly?
   
   - [ ] Have you written or updated unit tests to verify your changes?
   
   - [ ] If adding new dependencies to the code, are these dependencies licensed in a way that is compatible for inclusion under [ASF 2.0](http://www.apache.org/legal/resolved.html#category-a)?
   
   ### Note:
   Please ensure that once the PR is submitted, check Concourse for build issues and
   submit an update to your PR as soon as possible. If you need help, please send an
   email to dev@geode.apache.org.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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