Re: Crash in BRIN minmax-multi indexes
| От | Zhihong Yu |
|---|---|
| Тема | Re: Crash in BRIN minmax-multi indexes |
| Дата | |
| Msg-id | CALNJ-vSxOD2aUMZ7vTLSXUh_bgkzyLAbHST4cXxFpd7a8O6dsQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Crash in BRIN minmax-multi indexes (Jaime Casanova <jcasanov@systemguards.com.ec>) |
| Ответы |
Re: Crash in BRIN minmax-multi indexes
|
| Список | pgsql-hackers |
Hi,
In build_distances():
a1 = eranges[i].maxval;
a2 = eranges[i + 1].minval;
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 по дате отправления: