Re: jsonb crash

On 9/29/21 4:00 PM, Tom Lane wrote:
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
>> 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
>> """
> I think this must be a memoize bug. AFAICS, nowhere in this query
> can we be processing a non-null JSONB value, so what are we doing
> in jsonb_hash? Something down-stack must have lost the information
> that the Datum is actually null.

Yeah, confirmed that this is not failing in release 13.

cheers

andrew

--

Andrew Dunstan
EDB: https://www.enterprisedb.com