Hello.
We are evaluating the CMIS Interface with the Content Server 10. And therefore we are trying to implement a CMIS query using a timestamp constraint. For testing purposes we use the Apache Chemistry Workbench. The query which we want to trigger looks like the following:
SELECT cmis:objectId FROM cmis:document WHERE cmis:lastModificationDate < TIMESTAMP '2013-02-06T13:50:39.029'
If we exclude the WHERE part the query works fine, but whenever we are using the WHERE - part with the timestamp we are getting a Bad Request failure. The workbench log info tells this:
<body><h1>HTTP Status 400 - Error in CMISQL statement! - type : INVALID_ARGUMENT - code : 20005 - Cause message [com.opentext.ecm.services.cmis.query.parser.CmisSqlException: line 1:74 mismatched input 'TIMESTAMP' expecting set null]</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Error in CMISQL statement! - type : INVALID_ARGUMENT - code : 20005 - Cause message [com.opentext.ecm.services.cmis.query.parser.CmisSqlException: line 1:74 mismatched input 'TIMESTAMP' expecting set null]</u></p><p><b>description</b> <u>The request sent by the client was syntactically incorrect (Error in CMISQL statement! - type : INVALID_ARGUMENT - code : 20005 - Cause message [com.opentext.ecm.services.cmis.query.parser.CmisSqlException: line 1:74 mismatched input 'TIMESTAMP' expecting set null]).</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/6.0.35</h3></body>
So we assume that the timstamp is syntactically incorrect. So how it has to be? The used syntax is the one from the spec. Can anyone provide some help? That would be great.
Best regards,
Yves
