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

["Alberto Bustamante Reyes (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GEODE-8179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alberto Bustamante Reyes updated GEODE-8179:
--------------------------------------------
    Labels: pull-request-available  (was: )

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