From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | jsonb crash |
Date: | 2021-09-29 18:55:44 |
Message-ID: | 20210929185544.GB24346@ahch-to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I found a crash (segmentation fault) on jsonb.
This is the best I could do to reduce the query:
"""
select
75 as c1
from
public.pagg_tab_ml as ref_0,
lateral (select
ref_0.a as c5
from generate_series(1, 300) as sample_0
fetch first 78 rows only
) as subq_0
where case when (subq_0.c5 < 2)
then cast(null as jsonb)
else cast(null as jsonb)
end ? ref_0.c
"""
And because it needs pagg_tab_ml it should be run a regression database.
This affects at least 14 and 15.
Attached is the backtrace.
--
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL
Attachment | Content-Type | Size |
---|---|---|
jsonbcrash.txt | text/plain | 9.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ranier Vilela | 2021-09-29 19:16:44 | Re: jsonb crash |
Previous Message | Robert Haas | 2021-09-29 18:43:53 | Re: when the startup process doesn't (logging startup delays) |