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