[
https://issues.apache.org/jira/browse/GEODE-8962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288710#comment-17288710
]
ASF GitHub Bot commented on GEODE-8962:
---------------------------------------
nabarunnag commented on a change in pull request #6044:
URL: https://github.com/apache/geode/pull/6044#discussion_r580678544
##########
File path:
geode-dunit/src/main/java/org/apache/geode/management/internal/cli/commands/QueryCommandDUnitTestBase.java
##########
@@ -141,6 +141,19 @@ public void testSimpleQuery() {
new String[] {"ID", "status", "createTime", "pk", "floatMinValue"});
}
+ @Test
+ public void testSimpleQueryWithEscapingCharacter() {
+ server1.invoke(() ->
prepareDataForRegionWithSpecialCharacters(DATA_PAR_REGION_NAME_PATH));
+ String query = "query --query=\"select * from " + DATA_PAR_REGION_NAME_PATH
+ + " e where e LIKE 'value\\$'\"";
+ String query1 = "query --query=\"select * from " +
DATA_PAR_REGION_NAME_PATH
+ + " e where e LIKE 'value\\%'\"";
+ CommandResult commandResult = gfsh.executeCommand(query);
+ CommandResult commandResult1 = gfsh.executeCommand(query1);
+ validateSelectResult(commandResult, true, 1, null);
+ validateSelectResult(commandResult1, true, 1, null);
Review comment:
```suggestion
gfsh.executeAndAssertThat(query).statusIsSuccess().containsOutput("value$");
gfsh.executeAndAssertThat(query1).statusIsSuccess().containsOutput("value%");
```
----------------------------------------------------------------
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:
[email protected]
> 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
>
> {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)
