MinJi Kim created CALCITE-1945:
----------------------------------
Summary: Allow custom return types for AVG/VARIANCE/STDDEV/COVAR
Key: CALCITE-1945
URL: https://issues.apache.org/jira/browse/CALCITE-1945
Project: Calcite
Issue Type: Bug
Reporter: MinJi Kim
Assignee: Julian Hyde
For example, return types of AVG() is the input type. So, if the input is
INT/BIGINT type, AVG() is always truncated. Depending on the database, some
database follow this behavior while others (e.g. Oracle/MySQL/etc.) do not and
return floating point values for AVG().
Similar for other functions mentioned here.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
