You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@usergrid.apache.org by "Brandon Shelley (JIRA)" <ji...@apache.org> on 2015/09/29 18:51:04 UTC
[jira] [Updated] (USERGRID-1041) Implement means of escaping
single-quote characters in ql
[ https://issues.apache.org/jira/browse/USERGRID-1041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Shelley updated USERGRID-1041:
--------------------------------------
Description:
Given the entity:
{code}{
"title": "Charlotte's Web"
}{code}
These queries do not return any results:
{code}?ql=select * where title='Charlotte's Web'
?ql=select * where title='Charlotte%27s Web'{code}
We should support a means of escaping ' characters in text. Possible solutions:
- Using a backslash to denote escaped quotes
- Support alternative delimiters in the query
- Decode hex % encoded characters (but then what do we do for string literals?)
was:
Given the entity:
{code}{
"title": "Charlotte's Web"
}{code}
These queries do not return any results:
{code}?ql=select * where title='Charlotte%27s Web'
?ql=select * where title='Charlotte%27s Web'{code}
We should support a means of escaping ' characters in text. Possible solutions:
- Using a backslash to denote escaped quotes
- Support alternative delimiters in the query
- Decode hex % encoded characters (but then what do we do for string literals?)
> Implement means of escaping single-quote characters in ql
> ---------------------------------------------------------
>
> Key: USERGRID-1041
> URL: https://issues.apache.org/jira/browse/USERGRID-1041
> Project: Usergrid
> Issue Type: Improvement
> Affects Versions: 2.1.0
> Reporter: Brandon Shelley
> Priority: Minor
>
> Given the entity:
> {code}{
> "title": "Charlotte's Web"
> }{code}
> These queries do not return any results:
> {code}?ql=select * where title='Charlotte's Web'
> ?ql=select * where title='Charlotte%27s Web'{code}
> We should support a means of escaping ' characters in text. Possible solutions:
> - Using a backslash to denote escaped quotes
> - Support alternative delimiters in the query
> - Decode hex % encoded characters (but then what do we do for string literals?)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)