What happens? When using a window function with rows between unbounded preceding and unbounded following window functions will sometimes return nulls instead of the aggregate response. I have narrowed ...

The window function: first (year_total) over ( partition by sale_customer__id order by sale_date__year range between 1 following and 1 following ) returns values for some records when it should return ...