Try
Home   >   mailing lists

Re: BUG #18997: Two equivalent queries return different results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18997: Two equivalent queries return different results
Date
Msg-id 1672783.1753378416@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18997: Two equivalent queries return different results  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18997: Two equivalent queries return different results
List pgsql-bugs
Tree view 
PG Bug reporting form <noreply@postgresql.org> writes:
> I think these "SELECT COUNT(c0) FILTER (WHERE c0 IS NOT NULL) FROM t0" and
> "SELECT COUNT(c0) FROM t0 WHERE c0 IS NOT NULL;" are equivalent. However,
> their results are different.

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

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: BUG #18964: `ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist
Next
From: "Jinhui Lai"
Date:
Subject: Re: BUG #18997: Two equivalent queries return different results