Re: remaining sql/json patches

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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'

> Erik

In response to


Browse pgsql-hackers by date

  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