Hi,
I agree that for the windowing function, in the absence of any value the
sum shall be NULL, not 0.
Cheers,
Pau.
Missatge de Stamatis Zampetakis del dia dt., 22 de nov.
2022 a les 11:26:
> Hello,
>
> Regarding the inconsistency you describe in the window function, indeed it
> seems to be a
Hello,
Regarding the inconsistency you describe in the window function, indeed it
seems to be a bug. However, I would double-check with the SQL standard
to be sure there is no intentional deviation and/or test the query in
different DBMS.
As far as it concerns the behavior of the aggregate functi