Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong results due to qual pushdown - Mailing list pgsql-hackers

From Tom Lane
Subject Re: wrong results due to qual pushdown
Date
Msg-id 3351639.1678115526@sss.pgh.pa.us
Whole thread Raw
In response to wrong results due to qual pushdown  (tender wang <tndrwang@gmail.com>)
List pgsql-hackers
Tree view 
tender wang <tndrwang@gmail.com> writes:
> It looks wrong that the qual (e.g ((l_suppkey IS NOT NULL) OR
> (getdatabaseencoding() !~~ CASE WHEN ($0 OR NULL::boolean) THEN NULL::text
> ELSE NULL::text END))) is pushdown.

I think this is the same issue reported at [1].

            regards, tom lane

[1] https://www.postgresql.org/message-id/0b819232-4b50-f245-1c7d-c8c61bf41827%40postgrespro.ru

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)
Next
From: Matthias van de Meent
Date:
Subject: Re: Combine pg_walinspect till_end_of_wal functions with others