From: Alexander Lakhin <exclusion@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Neil Chen <carpenter.nail.cz@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>
Subject: Re: BUG #17066: Cache lookup failed when null (unknown) is passed as anycompatiblemultirange
Date: Fri, 25 Jun 2021 07:00:00 +0300
Message-ID: <c5269c65-f967-77c5-ff7c-15e621c47f6a@gmail.com> (raw)
In-Reply-To: <2549561.1624491310@sss.pgh.pa.us>
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>
Hello,
24.06.2021 02:35, Tom Lane wrote:
> Alexander Korotkov <aekorotkov@gmail.com> writes:
>> I really appreciate a hint here.
> I think I'm to blame for most of that code originally, so I'll take
> a look soon. Been up to my neck in other stuff recently.
I'm not sure whether it related to the initial issue, but there is
another anomaly with the multirange types. (May be I should report it as
a distinct bug?) The query:
create table test_multirange(mr int4multirange);
select count(*) from test_multirange where mr << int4range(100,100);
produces:
ERROR: unexpected operator 4396
while
select count(*) from test_multirange where mr << int4range(100,500);
returns a result (as the multirangetypes test shows).
Best regards,
Alexander
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: exclusion@gmail.com, tgl@sss.pgh.pa.us, aekorotkov@gmail.com, alvherre@2ndquadrant.com, carpenter.nail.cz@gmail.com, pgsql-bugs@lists.postgresql.org, pj@illuminatedcomputing.com
Subject: Re: BUG #17066: Cache lookup failed when null (unknown) is passed as anycompatiblemultirange
In-Reply-To: <c5269c65-f967-77c5-ff7c-15e621c47f6a@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox