Re: BUG #18997: Two equivalent queries return different results

Dear Tom Lane,

Sorry for my careless. I check my PG version again, it is  17.4. Since my PG docker' tag is latest, I mistakenly thought it was the latest version (17.5).

Thanks for your reply.

Best regards,

Jinhui

原始邮件


发件人：Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us&gt;
发件时间：2025年7月25日 01:33
收件人：jinhui-lai <jinhui-lai(at)foxmail(dot)com&gt;
抄送：pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org&gt;
主题：Re: BUG #18997: Two equivalent queries return different results

PG&nbsp;Bug&nbsp;reporting&nbsp;form&nbsp;<noreply(at)postgresql(dot)org&gt;&nbsp;writes:
&gt;&nbsp;I&nbsp;think&nbsp;these&nbsp;"SELECT&nbsp;COUNT(c0)&nbsp;FILTER&nbsp;(WHERE&nbsp;c0&nbsp;IS&nbsp;NOT&nbsp;NULL)&nbsp;FROM&nbsp;t0"&nbsp;and
&gt;&nbsp;"SELECT&nbsp;COUNT(c0)&nbsp;FROM&nbsp;t0&nbsp;WHERE&nbsp;c0&nbsp;IS&nbsp;NOT&nbsp;NULL;"&nbsp;are&nbsp;equivalent.&nbsp;However,
&gt;&nbsp;their&nbsp;results&nbsp;are&nbsp;different.

You&nbsp;sure&nbsp;your&nbsp;server&nbsp;is&nbsp;17.5,&nbsp;and&nbsp;not&nbsp;something&nbsp;a&nbsp;little&nbsp;older?
There&nbsp;was&nbsp;a&nbsp;bug&nbsp;of&nbsp;this&nbsp;sort&nbsp;in&nbsp;earlier&nbsp;17.x&nbsp;releases,&nbsp;but
we&nbsp;fixed&nbsp;it&nbsp;in&nbsp;17.5.&nbsp;&nbsp;For&nbsp;me,&nbsp;both&nbsp;queries&nbsp;produce&nbsp;"0"&nbsp;as
expected.

regards, tom&nbsp;lane