Re: nodeWindowAgg.c IGNORE NULLS abs overflow

Hi Jian,

> Hi.
>
> SELECT v,
> lead(v, -2147483648) OVER w AS respect_nulls,
> lead(v, -2147483648) IGNORE NULLS OVER w AS ignore_nulls
> FROM (VALUES (1), (2)) AS t(v)
> WINDOW w AS (ORDER BY v);
>
> should return all NULL values for column ignore_nulls.
>
> The fix is to replace the abs function in nodeWindowAgg.c with pg_abs_s32.

Thank you for the report and the fix. Unfortunately I have no time to
take care this for now (till November 3rd). I will work on this after
November 4th unless someone beats me.

Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp