[teiid-issues] [JBoss JIRA] (TEIID-5303) MongoDB translator issues with aggregate function expressions

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5303:
----------------------------------
    Fix Version/s: 12.x
                       (was: 11.x)


> MongoDB translator issues with aggregate function expressions
> -------------------------------------------------------------
>
>                 Key: TEIID-5303
>                 URL: https://issues.jboss.org/browse/TEIID-5303
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7
>            Reporter: Steven Hawkins
>            Priority: Major
>             Fix For: 12.x
>
>
> MongoDB queries involing expressions with aggregate functions in the select or having clauses will fail.  It appears that another projection phase is needed to handling those computations as they are not valid in the group operation.
> For example, these result in exceptions:
> SELECT min(e1)+1, e2 FROM TIME_TEST GROUP BY e2
> SELECT min(e1), e2 FROM TIME_TEST GROUP BY e2 HAVING year(e2) + count(\*) = 2



--
This message was sent by Atlassian Jira
(v7.12.1#712002)