-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Not A Bug
-
Affects Version/s: 5.2 GA
-
Fix Version/s: 5.3 GA
-
Component/s: None
-
Environment:PostgreSql 8.3
As the attached test case is showing the following queries don't return the expected result:
1) Modify a document, retrieve the modificationDate from the database and then search for documents with the same title and this modification time
(using the format : yyyy-MM-dd HH:mm:ss ) . The document is not found.
- When searching for documents modified before actual modificationTime + 1 second the document is found
2) Search for documents modified before actual modificationTime + 1 second but using the org.nuxeo.ecm.core.query.sql.model to build the query ( WhereClause).
When the query is build the modificationTime is formated with the time zone and the document is not found.