Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: fuboat(at)outlook(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause
Date: 2023-09-05 02:04:33
Message-ID: 1237514.1693879473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> BTW, do you think get_name_for_var_field() has similar problem for
> RTE_SUBQUERY case? The RTE_CTE code path in that function crawls up the
> namespace stack before recursing into the CTE while the RTE_SUBQUERY
> code patch does not, which looks like an oversight.

Hmm, seems suspicious ...

> I tried to find a
> test case to show it's indeed a problem but with no luck.

Note that any test case here would be of the form "dump a view
or rule definition", not "EXPLAIN". What did you try?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2023-09-05 02:25:11 Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler
Previous Message Laurenz Albe 2023-09-05 01:51:19 Re: BUG #18083: not compile PostgreSQL module in Qt with GCC 11.2 compiler