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