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)
