Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1m8P9p-0005Ox-Sw
	for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Jul 2021 15:38:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1m8P9o-0003FO-RB
	for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Jul 2021 15:38:12 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1m8P9o-0003FG-KQ
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Jul 2021 15:38:12 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1m8P9m-0006Oc-Mn
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Jul 2021 15:38:12 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 16RFc7H6305035;
	Tue, 27 Jul 2021 11:38:07 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Korotkov <aekorotkov@gmail.com>
cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
        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>
Subject: Re: BUG #17066: Cache lookup failed when null (unknown) is passed as
 anycompatiblemultirange
In-reply-to: 
 <CAPpHfdsb4jsVDWsajAMK032vw2vqUHPaXL02xsuK=zy7FZ1trw@mail.gmail.com>
References: 
 <CAA3qoJ=gMC8Uvz1VoO3BUoPCTByBmoJ8aXzLGQoK3RseyqcdCQ@mail.gmail.com>
 <202106221342.lab2x5tvhcbs@alvherre.pgsql>
 <CAPpHfdtT+Nq+ERXBku-XsVvsqS+amrt__bogy1WSnxhZPCJOcA@mail.gmail.com>
 <CAPpHfdtT8NJGcBzx6OnDxMOrp0BjPsFjCLrL82xqFa4639R7Nw@mail.gmail.com>
 <CAPpHfduRX=mft=30bcTmzPKm859Pjwpqk7TTkEy-6GddUxTpFA@mail.gmail.com>
 <CAPpHfdu4MhM_rrdGf6uZN9uh2=9ay-a2s=bpVzG_BoTSD4RU_w@mail.gmail.com>
 <2549561.1624491310@sss.pgh.pa.us>
 <CAPpHfduOx3UgF1fmThMj8XrgDhsxxE1DWAF4oR6z2EeVJ+PVtQ@mail.gmail.com>
 <640279.1626818095@sss.pgh.pa.us>
 <CAPpHfdsb4jsVDWsajAMK032vw2vqUHPaXL02xsuK=zy7FZ1trw@mail.gmail.com>
Comments: In-reply-to Alexander Korotkov <aekorotkov@gmail.com>
	message dated "Tue, 27 Jul 2021 18:34:10 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <305033.1627400287.1@sss.pgh.pa.us>
Date: Tue, 27 Jul 2021 11:38:07 -0400
Message-ID: <305034.1627400287@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/305034.1627400287%40sss.pgh.pa.us>
Precedence: bulk

Alexander Korotkov <aekorotkov@gmail.com> writes:
> On Wed, Jul 21, 2021 at 12:54 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> In any case, apologies for taking so long to get back to this.  Here's
>> a proposed patch (based in part on Neil's earlier patch).

> This patch looks good to me.  Besides fixing the particular bug
> report, it seems that the situation of mismatching range and
> multirange types in arguments is now handled correctly.

Thanks for reviewing!  I'll push it later today.

			regards, tom lane