Thanks Ryan for pointing back to the source, this helps. Am I correct that we have excluded a syntax change for the errata, because this would break compatibility? This means we still have to follow the double escaping rules. I think beside the example some more text would be helpful mentioning that:
· For CONTAINS double escaping needs to be performed (CMIS escaping for text search expressions according to 2.1.10.3 and SQL escaping to get a valid character string literal)
· We should state the order in which both escapings have to be performed (e.g. first CMIS escaping, then SQL escaping)
· Have the example
If I follow these rules I come to the following conclusion:
That’s -> That\’s // CMIS Escaping rule by backslashes according to section 2.1.10.3 of the spec
That’\s -> That\’’s // SQL escaping rule, double a single quote
That\’’s -> ‘That\’’s ‘ // put single quotes around it to get a valid SQL character string literal
Where is the point where I am wrong?
Looking back at CMIS-660 It seems that we first discussed a syntax change that we later have postponed to a later spec revision. It might be possible that we still have some uncertainties what we actually see in place for 1.0.
Jens
From: Ryan McVeigh [mailto:rmcveigh@ziaconsulting.com]
Sent: Mittwoch, 19. Januar 2011 18:45
To: Jens Hübel
Cc: florian.mueller@alfresco.com; cmis@lists.oasis-open.org
Subject: Re: [cmis] Groups - cmis-spec-v1.0e1-draft.doc uploaded
Jens,
This was taken from the comments of CMIS-660, specifically Florent's comment. If the doc isn't clear yet, we haven't successfully generated our errata. :) Let me know if after reading Florent's comment if this makes sense and how we can further clarify.
Thanks,
-Ryan
On Wed, Jan 19, 2011 at 10:41 AM, Jens Hübel <jhuebel@opentext.com> wrote:
I have a question regarding
2.20 CMIS-697: Word plus phrase example for CONTAINS query
o Ultimately yielding a query with: AND CONTAINS(‘that\\\’s’)
Can someone explain please why we need to escape the backslash? I can't find any rule like this in the SQL-92 syntax.
Thanks Jens
-----Original Message-----
From: florian.mueller@alfresco.com [mailto:florian.mueller@alfresco.com]
Sent: Mittwoch, 19. Januar 2011 16:26
To: cmis@lists.oasis-open.org
Subject: [cmis] Groups - cmis-spec-v1.0e1-draft.doc uploaded
The document revision named cmis-spec-v1.0e1-draft.doc has been submitted
by Mr. Florian Mueller to the OASIS Content Management Interoperability
Services (CMIS) TC document repository. This document is revision #1 of
cmis-spec-v1.0e1-draft.doc.
Document Description:
View Document Details:
http://www.oasis-open.org/committees/document.php?document_id=40811
Download Document:
http://www.oasis-open.org/committees/download.php/40811/cmis-spec-v1.0e1-draft.doc
Revision:
This document is revision #1 of cmis-spec-v1.0e1-draft.doc. The document
details page referenced above will show the complete revision history.
PLEASE NOTE: If the above links do not work for you, your email application
may be breaking the link into two pieces. You may be able to copy and paste
the entire link address into the address field of your web browser.
-OASIS Open Administration
--
Ryan McVeigh
Director of Enterprise Integration
office: 303.443.4004 x204
cell: 720.841.4838
fax: 877.569.7942
Follow Me: