Re: remaining sql/json patches

Hi Erik,

On Thu, Nov 16, 2023 at 13:52 Erik Rijkers <er(at)xs4all(dot)nl> wrote:

> 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?

Wow, will look. Thanks.

>