| 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: | Whole Thread | Raw Message | 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) |