Re: Crash in BRIN minmax-multi indexes - Mailing list pgsql-hackers

From Zhihong Yu
Subject Re: Crash in BRIN minmax-multi indexes
Date
Msg-id CALNJ-vSxOD2aUMZ7vTLSXUh_bgkzyLAbHST4cXxFpd7a8O6dsQ@mail.gmail.com
Whole thread Raw
In response to Crash in BRIN minmax-multi indexes  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: Crash in BRIN minmax-multi indexes  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers
Hi,
In build_distances():

        a1 = eranges[i].maxval;
        a2 = eranges[i + 1].minval;

It seems there was overlap between the successive ranges, leading to
delta = -6785000000

FYI

On Wed, Mar 31, 2021 at 10:30 AM Jaime Casanova <jcasanov@systemguards.com.ec> wrote:
Hi,

Just found $SUBJECT involving time with time zone and a subselect. I
still don't have narrowed to the exact table/index minimal schema but
if you run this query on the regression database it will creash.

```
update public.brintest_multi set
  timetzcol = (select tz from generate_series('2021-01-01'::timestamp
with time zone, '2021-01-31', '5 days') tz limit 1)
;
```

attached a backtrace. Let me know if you need extra information.

--
Jaime Casanova
Director de Servicios Profesionales
SYSTEMGUARDS - Consultores de PostgreSQL

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ModifyTable overheads in generic plans
Next
From: Tomas Vondra
Date:
Subject: Re: Crash in BRIN minmax-multi indexes