Re: Problem, partition pruning for prepared statement with IS NULL clause.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Sergei Glukhov <s(dot)glukhov(at)postgrespro(dot)ru>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Problem, partition pruning for prepared statement with IS NULL clause.
Date: 2023-10-06 21:00:54
Message-ID: ZSB1hnquhK0ss4F4@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Oct 6, 2023 at 06:09:45PM +0400, Sergei Glukhov wrote:
> Test case:
> ------
> set plan_cache_mode to force_generic_plan;
> prepare stmt AS select * from hp where a is null and b = $1;
> explain execute stmt('xxx');
> ------

I can confirm the crash in git master.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2023-10-06 21:02:43 Re: Problem, partition pruning for prepared statement with IS NULL clause.
Previous Message Bruce Momjian 2023-10-06 20:46:01 Re: [PoC/RFC] Multiple passwords, interval expirations