From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
---|---|
To: | Erik Rijkers <er(at)xs4all(dot)nl> |
Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, 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-11-16 06:53:30 |
Message-ID: | CA+HiwqF14cAgG7e0SJ90VXd8OKPzeRLBAn3p=-R8JV7H+M35fA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Nov 16, 2023 at 1:57 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> 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:
>> > [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
Attachment | Content-Type | Size |
---|---|---|
v25-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch | application/octet-stream | 2.3 KB |
v25-0001-Add-soft-error-handling-to-some-expression-nodes.patch | application/octet-stream | 9.1 KB |
v25-0002-Add-soft-error-handling-to-populate_record_field.patch | application/octet-stream | 23.2 KB |
v25-0004-JSON_TABLE.patch | application/octet-stream | 165.3 KB |
v25-0003-SQL-JSON-query-functions.patch | application/octet-stream | 199.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Bapat | 2023-11-16 07:02:53 | Re: Infinite Interval |
Previous Message | Amul Sul | 2023-11-16 06:07:26 | Re: retire MemoryContextResetAndDeleteChildren backwards compatibility macro |