Re: Problem, partition pruning for prepared statement with IS NULL clause. - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problem, partition pruning for prepared statement with IS NULL clause.
Date
Msg-id ZSB1840wfTVsbuFD@momjian.us
Whole thread Raw
In response to Re: Problem, partition pruning for prepared statement with IS NULL clause.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Fri, Oct  6, 2023 at 05:00:54PM -0400, Bruce Momjian wrote:
> 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.

There were some UTF8 non-space whitespace characters in the email so
attached is a clean reproducable SQL crash file.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.

Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Problem, partition pruning for prepared statement with IS NULL clause.
Next
From: Bruce Momjian
Date:
Subject: Re: Where can I find the doxyfile?