Horton
Menu

Re: Fwd: pg18 bug? SELECT query doesn't work

Richard Guo <guofenglinux@gmail.com>

View thread
From: Richard Guo <guofenglinux@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Eric Ridge <eebbrr@gmail.com>, Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-01-09T09:52:00Z
Lists: pgsql-hackers, pgsql-general

Attachments

On Thu, Jan 8, 2026 at 10:30 PM Richard Guo <guofenglinux@gmail.com> wrote:
> How about we add a comment to check_output_expressions() along the
> below lines?

I've worked on the comment a bit more in the attached patch, which
also includes my previously proposed code changes and some test cases.

I think this patch is suitable for fixing the current bug in the back
branches.  We can use a separate patch for the more ambitious goal of
moving the push-down of subquery's restriction clauses into
subquery_planner().

Any thoughts?

- Richard

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix unsafe pushdown of quals referencing grouping Vars

  2. Introduce an RTE for the grouping step