Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.37.0
Description
STDDEV_SAMP can return NULL even if the input is non-null and non-empty - it returns NULL when the input set has only one element. E.g. see the Oracle documentation: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/VAR_SAMP.html
Attachments
Issue Links
- relates to
-
CALCITE-6548 Result type inferred for COVAR_SAMP、COVAR_POP is incorrect
- Open
- links to