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 < jcasa...@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 >