Re: remaining sql/json patches

On Thu, Nov 16, 2023 at 1:57 PM Amit Langote <amitlangote09@gmail.com> wrote:
> On Thu, Nov 16, 2023 at 13:52 Erik Rijkers <er@xs4all.nl> wrote:
>> Op 11/15/23 om 14:00 schreef Amit Langote:
>>  > [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.

Should be fixed in the attached.  The bug was caused by the recent
redesign of JsonExpr evaluation steps.

Your testing is very much appreciated.  Thanks.

--
Thanks, Amit Langote
EDB: http://www.enterprisedb.com