| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com> |
| Subject: | Re: remaining sql/json patches |
| Date: | 2023-09-18 11:53:55 |
| Message-ID: | 4ec458ea-450e-0c3d-45bb-415e2b8d0afe@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2023-09-18 12:11:13 | Re: Allow specifying a dbname in pg_basebackup connection string |
| Previous Message | Daniel Gustafsson | 2023-09-18 11:53:28 | Re: Fix GIST readme on LSN vs NSN |