From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: bernddorn@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17227: segmentation fault with jsonb_to_recordset
Date: Wed, 13 Oct 2021 10:59:06 -0300
Message-ID: <202110131359.a6m35hpudkg7@alvherre.pgsql> (raw)
In-Reply-To: <17227-5a28ed1512189fa4@postgresql.org>
On 2021-Oct-13, PG Bug reporting form wrote:
> ```
> select *
> from (
> select jsonb_path_query_array(module -> 'lectures', '$[*]') as
> lecture
> from unnest(
> array[$${
> "lectures": [
> {
> "id": "1"
> }
> ]
> }$$::jsonb]) as unnested_modules(module)
> ) as l,
> jsonb_to_recordset(l.lecture) as (id text)
> limit 1;
> ```
Can you provide some sample data that would reproduce the crash?
--
Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/
"It takes less than 2 seconds to get to 78% complete; that's a good sign.
A few seconds later it's at 90%, but it seems to have stuck there. Did
somebody make percentages logarithmic while I wasn't looking?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, bernddorn@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17227: segmentation fault with jsonb_to_recordset
In-Reply-To: <202110131359.a6m35hpudkg7@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox