[jira] [Commented] (GEODE-8179) gfsh query command returns incorrect results if '=' sign is missing for query option

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GEODE-8179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17124323#comment-17124323 ] 

ASF GitHub Bot commented on GEODE-8179:
---------------------------------------

alb3rtobr commented on pull request #5187:
URL: https://github.com/apache/geode/pull/5187#issuecomment-637811188


   I have rebased the PR now that LGTM Java Analysis seems working again.


----------------------------------------------------------------
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:
users@infra.apache.org


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