Please see section 2.1.14.3 of the CMIS spec.
Text search needs double escaping:
Example:
A query statement that contains a
full-text search for the literal
string "John'sPresentation-Version2" may be
composed as:
SELECT ... FROM ... WHERE ...
CONTAINS('John\\\'sPresentation\\-Version2')
Jens
On 06.06.13 21:47, "Ian Ashley" <[email protected]> wrote:
>Dear all,
>
>I think that the query parser does not handle the escaping properly in
>CONTAINS searches. The queries below fail at the parsing stage
>
>SELECT cmis:objectId FROM Picture WHERE CONTAINS('Don\'t eat or drink
>this')
>SELECT cmis:objectId FROM Picture WHERE CONTAINS('Do not eat\\drink this')
>
>Regards,
>Ian
>
