geode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dodge (JIRA)" <j...@apache.org>
Subject [jira] [Created] (GEODE-2834) Query with WHERE clause unable to return values that include single-quotes inside strings
Date Thu, 27 Apr 2017 21:13:04 GMT
Michael Dodge created GEODE-2834:
------------------------------------

             Summary: Query with WHERE clause unable to return values that include single-quotes
inside strings
                 Key: GEODE-2834
                 URL: https://issues.apache.org/jira/browse/GEODE-2834
             Project: Geode
          Issue Type: Bug
          Components: gfsh
            Reporter: Michael Dodge


If one was to create a region and insert JSON values via the REST API and one of those values
happened to include a single-quote character inside a string, e.g.,:
{
   "PizzaType":"meat lover's",
   "Quantity":"1"
}

And then one was to execute a query using gfsh, e.g.:
gfsh>query --query="SELECT * FROM /orderrequests o WHERE o.PizzaType LIKE 'meat%'"

Then one would see an error as follows:
Error getting bean properties Expected a ',' or '}' at 26 [character 27 line 1]



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message