[
https://issues.apache.org/jira/browse/CALCITE-7695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu updated CALCITE-7695:
---------------------------------
Description:
COVAR_POP may produce NULL even when the input set is not empty.
For non-nullable arguments and GROUP BY the result type is incorrectly inferred
as not nullable.
Moreover, the type inference for the entire family of functions COVAR and REGR
does not look at the nullability of the second argument.
was:
The COVAR family of functions applied to an empty set produces NULL results.
For non-nullable arguments and GROUP BY the result type is incorrectly inferred
as not nullable.
> COVAR_POP result should always be nullable
> ------------------------------------------
>
> Key: CALCITE-7695
> URL: https://issues.apache.org/jira/browse/CALCITE-7695
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
>
> COVAR_POP may produce NULL even when the input set is not empty.
> For non-nullable arguments and GROUP BY the result type is incorrectly
> inferred as not nullable.
> Moreover, the type inference for the entire family of functions COVAR and
> REGR does not look at the nullability of the second argument.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
