Horton

Re: BUG #17066: Cache lookup failed when null (unknown) is passed as anycompatiblemultirange

Alexander Korotkov <aekorotkov@gmail.com>

View thread View on postgr.es
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Neil Chen <carpenter.nail.cz@gmail.com>, Alexander Law <exclusion@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, Paul A Jungwirth <pj@illuminatedcomputing.com>
Date: 2021-06-22T16:01:36Z
Lists: pgsql-bugs 
On Tue, Jun 22, 2021 at 4:42 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> On 2021-Jun-22, Neil Chen wrote:
>
> > Greetings,
> >
> > I tried to investigate the bug, but the complicated logic here completely
> > messed up my mind...
> >
> > Anyway, this patch can fix it and make the regress test happy. But I think
> > it's better to get the author's advice - I copied this email to Alvaro,
> > hope it doesn't offend him...
>
> Without looking too deeply, the patch seems sensible to me.  However,
> I'm CC'ing Alexander and Paul :-)

Thank you for pointing this out.  And thanks to Neil for the fix.

Looks good at the first glance.  I'm going to review this in the next
couple of days.

------
Regards,
Alexander Korotkov

Commits

  1. Fix bugs in polymorphic-argument resolution for multiranges.

  2. Fixes for multirange selectivity estimation