xiong duan created CALCITE-6548:
-----------------------------------
Summary: Result type inferred for COVAR_SAMP、COVAR_POP is incorrect
Key: CALCITE-6548
URL: https://issues.apache.org/jira/browse/CALCITE-6548
Project: Calcite
Issue Type: Improvement
Reporter: xiong duan
Assignee: xiong duan
COVAR_SAMP can return NULL. If the function is applied to an empty set, it
returns null. E.g. see the Oracle documentation:
[https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/VAR_SAMP.html|https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/COVAR_SAMP.html]
.
COVAR_POP see the Oracle documentation:
[https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/COVAR_POP.html|https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/COVAR_POP.html].
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
