Pressenna created CALCITE-3230: ---------------------------------- Summary: Explicit CASTs by user are not applied. Key: CALCITE-3230 URL: https://issues.apache.org/jira/browse/CALCITE-3230 Project: Calcite Issue Type: Bug Components: core Environment: For some reason casting is not working correctly with aggregate functions.
for example: {code:java} SELECT CAST(AVG(double_column) AS float) FROM foo GROUP BY group_coulmn; {code} does not apply the cast. We currently have to circumvent this by using following dummy construct. {code:java} SELECT CAST( (AVG(double_column) + 0.0) AS float) FROM foo GROUP BY group_coulmn; {code} Reporter: Pressenna -- This message was sent by Atlassian JIRA (v7.6.14#76016)