JSON constructors and window functions

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: pgsql-hackers(at)postgresql(dot)org
Cc: andrew(at)dunslane(dot)net, n(dot)gluhov(at)postgrespro(dot)ru
Subject: JSON constructors and window functions
Date: 2022-04-02 05:25:04
Message-ID: YkfeMNYRCGhySKyg@ahch-to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I got a crash running the below query on the regression database:

"""
select pg_catalog.json_object_agg_unique(10,
cast(ref_0.level2_no as int4))
over (partition by ref_0.parent_no
order by ref_0.level2_no)
from public.transition_table_level2 as ref_0;
"""

Attached the backtrace.

PS: I'm cc'ing Andrew and Nikita because my feeling is that this is
f4fb45d15c59d7add2e1b81a9d477d0119a9691a responsability.

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

Attachment Content-Type Size
gdb.txt text/plain 8.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rushabh Lathia 2022-04-02 06:08:47 Re: PostgreSQL shutdown modes
Previous Message Tom Lane 2022-04-02 05:10:39 Re: A test for replay of regression tests