[
https://issues.apache.org/jira/browse/GEODE-8179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17135486#comment-17135486
]
ASF subversion and git services commented on GEODE-8179:
--------------------------------------------------------
Commit 4477013a1656f3d94c8d36286fa497e4406da005 in geode's branch
refs/heads/mass-test-run from Alberto Bustamante Reyes
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=4477013 ]
GEODE-8179: gfsh query cmd returns incorrect results if '=' sign is missing
(#5187)
> gfsh query command returns incorrect results if '=' sign is missing for query
> option
> ------------------------------------------------------------------------------------
>
> Key: GEODE-8179
> URL: https://issues.apache.org/jira/browse/GEODE-8179
> Project: Geode
> Issue Type: Bug
> Components: gfsh
> Reporter: Eric Shu
> Assignee: Alberto Bustamante Reyes
> Priority: Major
> Labels: pull-request-available
>
> gfsh returns correct result when "=" is there for the query option:
> gfsh>query --query="Select ID from /portfolio where ID = 3"
> Result : true
> Limit : 100
> Rows : 1
> Result
> ------
> 3
> It returns wrong result when "=" is missing for the query option.
> gfsh>query --query "Select ID from /portfolio where ID <= 3 "
> Result : true
> Limit : 100
> Rows : 3
> Result
> ------
> 0
> 1
> 2
> gfsh>query --query "<trace> Select ID from /portfolio where ID = 3 "
> Result : false
> Message : Query is invalid due to error : <Syntax error in query: unexpected
> token: ID>
> gfsh>query --query "<trace> Select ID from /portfolio where ID == 3 "
> Result : true
> Limit : 100
> Rows : 1
> Query Trace : Query Executed in 0.968059 ms; indexesUsed(0)
> Result
> ------
> 3
> gfsh>query --query "<trace> Select ID from /portfolio where ID =<= 3 "
> Result : true
> Limit : 100
> Rows : 4
> Query Trace : Query Executed in 1.427194 ms; indexesUsed(0)
> Result
> ------
> 0
> 1
> 2
> 3
> Seems that first '=' in the query string is discarded by gfsh.
> Either fail the query if the query option'=' is missing or gfsh should return
> correct result from the query string.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
