Re: remaining sql/json patches - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: remaining sql/json patches
Date
Msg-id 4ec458ea-450e-0c3d-45bb-415e2b8d0afe@xs4all.nl
Whole thread Raw
In response to Re: remaining sql/json patches  (Erik Rijkers <er@xs4all.nl>)
Responses Re: remaining sql/json patches
List pgsql-hackers
Op 9/18/23 om 13:14 schreef Erik Rijkers:
> Op 9/18/23 om 12:20 schreef Amit Langote:
>> Hi Erik,
>>
>>> I am sorry to be bothering you with these somewhat idiotic SQL
>>> statements but I suppose somehow it needs to be made more solid.
>>
> 
> For 60 datatypes, I ran this statement:
> 
> select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
>   '$.a[*].a?(@<=3)'returning ${datatype} with wrapper
> );
>
> against a 17devel server (a0a5) with json v15 patches and caught the 
> output, incl. 30+ crashes, in the attached .txt. I hope that's useful.
> 

and FYI: None of these crashes occur when I leave off the 'WITH WRAPPER' 
clause.

> 
> Erik
> 



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Fix GIST readme on LSN vs NSN
Next
From: Daniel Gustafsson
Date:
Subject: Re: Allow specifying a dbname in pg_basebackup connection string