Date: Wed, 13 Oct 2021 10:59:06 -0300
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: bernddorn@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17227: segmentation fault with jsonb_to_recordset
Message-ID: <202110131359.a6m35hpudkg7@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <17227-5a28ed1512189fa4@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/202110131359.a6m35hpudkg7%40alvherre.pgsql>
Precedence: bulk

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?"