Re: JSON constructors and window functions - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: JSON constructors and window functions
Date
Msg-id bf6b1a7e-f0cf-6ee4-8875-829d99a097c0@dunslane.net
Whole thread Raw
In response to JSON constructors and window functions  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: JSON constructors and window functions
List pgsql-hackers
On 4/2/22 01:25, Jaime Casanova wrote:
> 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.



Hmm. Thanks for the report. The code in json_unique_check_key() looks
sane enough., so the issue is probably elsewhere. I'll keep digging.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix overflow in DecodeInterval
Next
From: Joseph Koshakow
Date:
Subject: Re: Fix overflow in DecodeInterval