Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.1
-
None
-
2018-21, 2019-01
Description
Our implementations of regr_avgx and regr_avgy explicitly return 0 if there are no numbers to avg. This can happen if all rows contain NULL or if the Window Frame is fully outside the data being considered.
PostgreSQL and Snowflake both return NULL in these cases.