Re: remaining sql/json patches

Op 11/15/23 om 14:00 schreef Amit Langote:
> Hi,

[..]

> Attached updated patch.  The version of 0001 that I posted on Oct 11
> to add the error-safe version of CoerceViaIO contained many
> unnecessary bits that are now removed.
>
> --
> Thanks, Amit Langote
> EDB: http://www.enterprisedb.com

 > [v24-0001-Add-soft-error-handling-to-some-expression-nodes.patch]
 > [v24-0002-Add-soft-error-handling-to-populate_record_field.patch]
 > [v24-0003-SQL-JSON-query-functions.patch]
 > [v24-0004-JSON_TABLE.patch]
 > [v24-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch]

Hi Amit,

Here is a statement that seems to gobble up all memory and to totally
lock up the machine. No ctrl-C - only a power reset gets me out of that.
It was in one of my tests, so it used to work:

select json_query(
     jsonb '"[3,4]"'
   , '$[*]' returning bigint[] empty object on error
);

Can you have a look?