Re: BUG #13514: PostgreSQL backend process crashes on jsonb_object_agg()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: b(dot)yordanov2(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: BUG #13514: PostgreSQL backend process crashes on jsonb_object_agg()
Date: 2015-07-23 03:14:53
Message-ID: 26929.1437621293@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

b(dot)yordanov2(at)gmail(dot)com writes:
> jsonb_object_agg() appears to fail when the second argument (in this case
> attributes->z->'tt') is a nonexistent jsonb column (there is
> attributes->z->'t' but not 'tt').

Seems to be failure to handle nulls properly. The attached patch stops
the crash for me, but I've not checked to see if the results are "right",
nor scouted around to see if there are similar bugs nearby.

regards, tom lane

Attachment Content-Type Size
jsonb-nulls-crash.patch text/x-diff 1.4 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message sushant 2015-07-23 04:56:17 BUG #13515: Much higher disk writes after postgres upgrade 9.4.3->9.4.4
Previous Message Alvaro Herrera 2015-07-22 22:47:59 Re: BUG #13490: Segmentation fault on pg_stat_activity