Re: BUG #17227: segmentation fault with jsonb_to_recordset - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #17227: segmentation fault with jsonb_to_recordset
Date
Msg-id 202110131359.a6m35hpudkg7@alvherre.pgsql
Whole thread Raw
In response to BUG #17227: segmentation fault with jsonb_to_recordset  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17227: segmentation fault with jsonb_to_recordset  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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?"



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17228: Adding 'syslog' to log_destination causes postgres service throw an error when restarted.
Next
From: Tom Lane
Date:
Subject: Re: BUG #17227: segmentation fault with jsonb_to_recordset