Re: BUG #17227: segmentation fault with jsonb_to_recordset
Alvaro Herrera <alvherre@alvh.no-ip.org>
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: bernddorn@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2021-10-13T13:59:06Z
Lists: 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?"
Commits
-
Fix planner error with pulling up subquery expressions into function RTEs.
- 4d5f651f1d65 15.0 landed
- fdd6a4d8d90a 13.5 landed
- fd059ac2e461 14.1 landed
-
Allow functions-in-FROM to be pulled up if they reduce to constants.
- 7266d0997dd2 13.0 cited