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

From Erik Rijkers
Subject Re: remaining sql/json patches
Date
Msg-id 92aa26e3-662b-3404-d92b-e88d42c18f23@xs4all.nl
Whole thread Raw
In response to Re: remaining sql/json patches  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: remaining sql/json patches
List pgsql-hackers
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.


Erik


Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Fix GIST readme on LSN vs NSN
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: [PoC] pg_upgrade: allow to upgrade publisher node