Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14876: Segmentation fault with JSONB column used instore proc that gets used by view and later altered - Mailing list pgsql-bugs

From Dmitry Dolgov
Subject Re: [BUGS] BUG #14876: Segmentation fault with JSONB column used instore proc that gets used by view and later altered
Date
Msg-id CA+q6zcVaseLjGTssxtr=yUkRY-sW8SKqPXsOpGsy10=u5UXWKA@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14876: Segmentation fault with JSONB column used in store procthat gets used by view and later altered  (samuel.horwitz@gmail.com)
List pgsql-bugs
Tree view
> On 26 October 2017 at 20:40, <samuel.horwitz@gmail.com> wrote:
>
> However, if I alter the stored procedure's resulting JSON in any way, this
> will cause selecting from the second view to trigger a segfault.

Yes, looks like I can reproduce this issue - from the first glance parse_relation.c:2216 is the culprit,
somehow aliasp_item is empty:

expandRTE (rte=<optimized out>, rtindex=3, sublevels_up=sublevels_up@entry=0, location=-1, include_dropped=1 '\001', colnames=colnames@entry=0x7ffda83c0bd0, colvars=0x7ffda83c0bd8) at parse_relation.c:2216
2216                                                    char       *label = strVal(lfirst(aliasp_item));
>>> p aliasp_item
$1 = (ListCell *) 0x0

pgsql-bugs by date:

Previous
From: samuel.horwitz@gmail.com
Date:
Subject: [BUGS] BUG #14876: Segmentation fault with JSONB column used in store procthat gets used by view and later altered
Next
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14876: Segmentation fault with JSONB column used instore proc that gets used by view and later altered