[teiid-issues] [JBoss JIRA] (TEIID-5303) MongoDB translator issues with aggregate function expressions
Steven Hawkins (JIRA)
issues at jboss.org
Thu Mar 29 12:33:00 EDT 2018
Steven Hawkins created TEIID-5303:
-------------------------------------
Summary: MongoDB translator issues with aggregate function expressions
Key: TEIID-5303
URL: https://issues.jboss.org/browse/TEIID-5303
Project: Teiid
Issue Type: Bug
Reporter: Steven Hawkins
Assignee: Steven Hawkins
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.5.0#75005)
More information about the teiid-issues
mailing list