[teiid-issues] [JBoss JIRA] (TEIID-5297) With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause

[Jan Martiska (JIRA)]

Jan Martiska created TEIID-5297:
-----------------------------------

             Summary: With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause
                 Key: TEIID-5297
                 URL: https://issues.jboss.org/browse/TEIID-5297
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
    Affects Versions: 8.12.11.6_4
            Reporter: Jan Martiska
            Assignee: Steven Hawkins


For example:
{noformat}
SELECT timestampvalue, second(timestampvalue) as sec FROM bqt1.hugeA WHERE second(timestampvalue) >= 0
{noformat}
This will correctly select rows where {{second(timestampvalue) >= 0}}, but the {{sec}} column in the result will contain only nulls.

If I remove the WHERE clause:
{noformat}
SELECT timestampvalue, second(timestampvalue) as sec FROM bqt1.hugeA;
{noformat}
Then the {{sec}} column will be computed correctly.




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