Re: BUG #15514: process fails on jsonb_populate_recordset query. see simple example below

Haribabu Kommi <kommi.haribabu@gmail.com>

From: Haribabu Kommi <kommi.haribabu@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: 4321ip <4321ip@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2018-11-22T23:23:37Z
Lists: pgsql-bugs
On Fri, Nov 23, 2018 at 7:21 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Haribabu Kommi <kommi.haribabu@gmail.com> writes:
> > Accessing of NULL pointer leads to crash. Attached quick simple patch
> fixes
> > the problem.
>
> While that stops the crash, it doesn't do what we want, which is to
> return a valid tupdesc.  Without that you get "set-valued function called
> in context that cannot accept a set" errors.  I think the right fix is
> to force a call of update_cached_tupdesc so that there always is a
> tupdesc to copy.
>

Thanks for checking, I thought of the same thing, but I wasn't sure.

Regards,
Haribabu Kommi
Fujitsu Australia

Commits

  1. Fix another crash in json{b}_populate_recordset and json{b}_to_recordset.