[teiid-issues] [JBoss JIRA] (TEIID-5376) Timezone handling discrepancies in MongoDB

[Jan Martiska (JIRA)]

Jan Martiska created TEIID-5376:
-----------------------------------

             Summary: Timezone handling discrepancies in MongoDB
                 Key: TEIID-5376
                 URL: https://issues.jboss.org/browse/TEIID-5376
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
            Reporter: Jan Martiska
            Assignee: Steven Hawkins


Suppose this query against a MongoDB-backed VDB and you're running it in timezone UTC+1:
{noformat}
SELECT timestampvalue, HOUR(timestampvalue) AS TheHour FROM BQT1.SmallA WHERE (HOUR(timestampvalue) = 16);
{noformat}
If the database contains a timestamp '2000-01-01 16:00:00', you will get this row as result:
||timestampvalue||TheHour||
|2000-01-01 17:00:00|16|

Looks like this is because the {{timestampvalue}} column is fully evaluated by Teiid and converted into the user's timezone, but the {{hour()}} call is pushed and evaluated by MongoDB and therefore evaluated as UTC and is not converted by Teiid to user's timezone. 





--
This message was sent by Atlassian JIRA
(v7.5.0#75005)