[OASIS Issue Tracker] Commented: (CMIS-567) CMIS-530 accepted, butmissed escaping question

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

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

Ryan McVeigh commented on CMIS-567:
-----------------------------------

Since we have adopted the SQL-style of escaping quotes, there is no longer any need for a general string escape using \.  The only way to escape quotes should be ''.

Now, we have two additional special cases (which should be documented as special cases, not in a general "Escaping" section.  Section 2.10.3 Escaping should be removed from the spec.

1) LIKE

Since LIKE has two characters with special meaning (the % and _ wildcards), SQL-92 recognized that you might need a way to match on those characters themselves.  So it has an optional ESCAPE predicate.  We didn't want to add this predicate to the query grammar, so it established a fixed escape character of \ (CMIS-180).

Thus, in a LIKE string, the character sequences \%, \_, and \\ represent the single characters %, _, and \, respectively.  Any other use of \ is an error.  And single-quotes are still escaped as in any other string ('').

This should be documented in a section entitled "LIKE Predicate", so it is clear that the escaping behavior is constrained to a string used in this predicate.

2) CONTAINS - Opened new issue CMIS-580



> CMIS-530 accepted, but missed escaping question
> -----------------------------------------------
>
>                 Key: CMIS-567
>                 URL: http://tools.oasis-open.org/issues/browse/CMIS-567
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Bug
>          Components: Domain Model
>    Affects Versions: Draft 0.70
>            Reporter: Ryan McVeigh
>            Assignee: Ethan Gur-esh
>
> What about the escaping that is the subject of the issue:
> Which of these styles do we need to support:
>    'Mary\'s little lamb' (per CMIS)
> and
>    'Mary''s little lamb' (per SQL)
> one or both??

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