| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Amit Langote <amitlangote09(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: remaining sql/json patches |
| Date: | 2023-11-16 04:53:23 |
| Message-ID: | 5ed17735-099b-45f9-11cb-0f8e472352af@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
Thanks,
Erik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2023-11-16 04:57:19 | Re: remaining sql/json patches |
| Previous Message | Peter Smith | 2023-11-16 03:53:42 | Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?) |