| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | natalya(at)timescale(dot)com |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org, Peter Geoghegan <pg(at)bowt(dot)ie> |
| Subject: | Re: BUG #19049: Assert failure when using skip arrays on an index key with DESC order |
| Date: | 2025-09-11 15:49:45 |
| Message-ID: | 1788650.1757605785@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> -- This query crashes with an Assert
> select distinct on(s0, s1) * from mv where t2 >= -1 and t1 < 10 order by
> s0, s1, t1 desc, t2 desc;
> Assert is:
> if (ScanDirectionIsForward(dir) && array->low_compare)
> Assert(DatumGetBool(FunctionCall2Coll(&array->low_compare->sk_func,
> array->low_compare->sk_collation, tupdatum, array->low_compare->sk_argument)));
Indeed. "git bisect" says this started at
b3f1a13f22f9e28842ee5fbd08b7ec805e27aaac is the first bad commit
commit b3f1a13f22f9e28842ee5fbd08b7ec805e27aaac
Author: Peter Geoghegan <pg(at)bowt(dot)ie>
Date: Fri Apr 4 14:14:08 2025 -0400
Avoid extra index searches through preprocessing.
Peter, you want to take a look?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2025-09-11 15:51:42 | Re: BUG #19049: Assert failure when using skip arrays on an index key with DESC order |
| Previous Message | Tom Lane | 2025-09-11 15:00:42 | Re: BUG #19050: psql: could not find digest for NID UNDEF |