chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Huebel, Jens" <j.hue...@sap.com>
Subject Re: Freetext search escaping
Date Mon, 10 Jun 2013 10:57:52 GMT
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" <iashley@opentext.com> 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
>


Mime
View raw message