[OASIS Issue Tracker] Commented: (CMIS-180) Clarify query escapebehavior.

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/CMIS-180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=10642#action_10642 ] 

Florent Guillaume commented on CMIS-180:
----------------------------------------

Yes escaping is quite important, to be able to pass arbitrary user-generated strings to a query backend.
I would therefore propose to use the complete SQL92 rules:

         <like predicate> ::= <match value> [ NOT ] LIKE <pattern> [ ESCAPE <escape character> ]
         <match value> ::= <character value expression>
         <pattern> ::= <character value expression>
         <escape character> ::= <character value expression>

with <escape character> of length 1 and the <pattern> following the SQL92 rules for its well-formedness.


> Clarify query escape behavior.
> ------------------------------
>
>                 Key: CMIS-180
>                 URL: http://tools.oasis-open.org/issues/browse/CMIS-180
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Bug
>          Components: Domain Model
>    Affects Versions: Draft 0.61
>            Reporter: Ryan McVeigh
>            Assignee: Ethan Gur-esh
>            Priority: Critical
>
> SQL92's LIKE predicate also has an optional ESCAPE argument. So, in regards to CMIS SQL, what are the like string escaping rules? As there is no way to specify an escape character in the grammar, is it simply not allowed (as in SQL92 without the ESCAPE clause)? Or is there some default escape character? What does it escape (i.e. just % and _, or does it escape quotes (which will modify the entire BNF, I think)?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira