Re: Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: akuluasan <akuluasan(at)163(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Richard Guo <guofenglinux(at)gmail(dot)com>, zuming(dot)jiang(at)inf(dot)ethz(dot)ch, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Re: BUG #18305: Unexpected error: "WindowFunc not found in subplan target lists" triggered by subqueries
Date: 2024-04-15 03:42:10
Message-ID: CAApHDvqEyBUvdTee-ou=fPN_0F31cvZqd67PqHQzvDW6ZG6YQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 1 Apr 2024 at 21:34, akuluasan <akuluasan(at)163(dot)com> wrote:
> I am using my tool to simplify the SQL query. Can you please confirm if the simplification process helps you diagnose and locate bugs?

The root cause of this has already been established, so in this case,
the answer is "no".

However, since you wrote "bugs" rather than "this bug", for cases
where we've not found the root cause, the more simple the reproducer,
the better.

David

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ronan Dunklau 2024-04-15 05:33:49 Re: FSM Corruption (was: Could not read block at end of the relation)
Previous Message Tom Lane 2024-04-14 16:44:37 Re: BUG #18429: Inconsistent results on similar queries with join lateral