Re: BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink"

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Cc: alpkeles99(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink"
Date: 2026-10-29 01:40:25
Message-ID: CA+HiwqFHTkR-fCg+-uUR=KzSnLnQn3jW6we+bLNOrjQragaLLg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Oct 28, 2026 at 11:41 PM Ayush Tiwari
<ayushtiwari(dot)slg01(at)gmail(dot)com> wrote:
> On Wed, 28 Oct 2026 at 16:10, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> > The fix makes sense. Here's that in a patch. I found another issue
> > like this where INSERT fails with the same error due to a missing
> > copyObject(), which I posted at [1].
>
> Thanks for the patch, I tested it and the changes lgtm.

Thanks, pushed.

--
Thanks, Amit Langote

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-10-29 02:12:30 RE: START_REPLICATION silently truncates an overlong LSN component
Previous Message David Rowley 2026-10-29 01:22:01 Re: BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path