-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Not A Bug
-
Affects Version/s: 2021.0
-
Fix Version/s: None
-
Component/s: Core VCS
-
Tags:
-
Backlog priority:650
-
Sprint:nxplatform #99
-
Story Points:3
Steps to reproduce:
- add this line to nuxeo.conf
JAVA_OPTS=$JAVA_OPTS -Duser.timezone="Europe/Paris"
- configure Nuxeo to use an Oracle database
- remove nxql_search from the ES page providers
- start nuxeo
- create a Note document
- edit the Note and set the "expired" field to July, 14 2023
- go to the NXQL search
- try this query
select * from Note where dc:expired = DATE '2023-07-14'
- observe that no result is returned
Expected result : the Note document is returned (this is the behavior in LTS 2029)
The problem is caused by the changes brought by NXP-26517 where the date literal is parsed by a formatter which converts the time based on the server local time
- is related to
-
NXDOC-2615 We should document the OS/JVM server timezone behavior
- Resolved
-
NXDOC-2616 Improve NXQL doc on DATE and TIMESTAMP regarding timezone
- Resolved