Timestamp queries not working as expected
-----------------------------------------
Key: NXP-4219
URL: http://jira.nuxeo.org/browse/NXP-4219
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Affects Versions: 5.3.x
Environment: PostgreSql 8.3
Reporter: Mariana Cedica
Assignee: Thierry Delprat
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
