Eric Shu created GEODE-8179: ------------------------------- Summary: 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
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)