Horton

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

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Neil Chen <carpenter.nail.cz@gmail.com>
Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org, Alexander Korotkov <aekorotkov@gmail.com>, Paul A Jungwirth <pj@illuminatedcomputing.com>
Date: 2021-06-22T13:42:18Z
Lists: pgsql-bugs 
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 :-)

-- 
Álvaro Herrera       Valdivia, Chile

Commits

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

  2. Fixes for multirange selectivity estimation