| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Eric Ridge <eebbrr(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fwd: pg18 bug? SELECT query doesn't work |
| Date: | 2026-01-09 09:52:00 |
| Message-ID: | CAMbWs48kk-f=7fCP5cCksZpc9n10CJEoe-edOoQfwMR6x0KNng@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thu, Jan 8, 2026 at 10:30 PM Richard Guo <guofenglinux(at)gmail(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Fix-unsafe-pushdown-of-quals-referencing-grouping.patch | application/octet-stream | 10.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksandr Fedorov | 2026-01-14 08:09:08 | Re: Error:could not extend file " with FileFallocate(): No space left on device |
| Previous Message | Peter 'PMc' Much | 2026-01-08 22:42:43 | Re: Collation again here |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-01-09 10:22:21 | Re: file_fdw: Support multi-line HEADER option. |
| Previous Message | Chao Li | 2026-01-09 09:42:36 | Re: GIN pageinspect support for entry tree and posting tree |