Re: BUG #19768: JSON_TABLE: row/text comparisons in context item or PASSING give wrong results or spurious collation

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Venu K <venu2805k(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, amitlan(at)postgresql(dot)org
Subject: Re: BUG #19768: JSON_TABLE: row/text comparisons in context item or PASSING give wrong results or spurious collation
Date: 2026-11-06 02:31:29
Message-ID: CA+HiwqEYW2fDrqwK0uhfLPrQY8kZOi-A5EkX8tnh8eyBnuibaQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Sat, Oct 24, 2026 at 4:14 AM Venu K <venu2805k(at)gmail(dot)com> wrote:
> Gentle ping on this. The bug still reproduces on current master
> (126976a), and the patch upthread still applies cleanly there. The
> one-line fix in parse_jsontable.c also applies to REL_17_STABLE and
> REL_18_STABLE; the regression test hunks need minor adjustment on
> those branches.
>
> CC'ing Amit as the committer of JSON_TABLE.

Thanks for notifying me.

Patch looks good. Here is v2, which I intend to commit down to 17 by
tomorrow barring objections.

--
Thanks, Amit Langote

Attachment Content-Type Size
v2-master-0001-JSON_TABLE-fix-missing-collation-assignmen.patch application/octet-stream 4.5 KB
v2-REL_17-19-0001-JSON_TABLE-fix-missing-collation-assign.patch application/octet-stream 4.5 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2026-11-06 07:52:21 Re: BUG #19780: gtsvector_picksplit() reads uninitialized data when called with three entries
Previous Message Tatsuo Ishii 2026-11-06 00:25:31 Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY)