| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | bernddorn(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17227: segmentation fault with jsonb_to_recordset |
| Date: | 2021-10-13 13:59:06 |
| Message-ID: | 202110131359.a6m35hpudkg7@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-10-13 14:28:55 | Re: BUG #17227: segmentation fault with jsonb_to_recordset |
| Previous Message | PG Bug reporting form | 2021-10-13 13:11:15 | BUG #17228: Adding 'syslog' to log_destination causes postgres service throw an error when restarted. |