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

[Mario Kevo (Jira)]

Mario Kevo created GEODE-8962:
---------------------------------

             Summary: 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


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