Re: is this a known bug in 9.6?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is this a known bug in 9.6?
Date: 2016-12-13 15:31:49
Message-ID: 31684.1481643109@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123(at)gmail(dot)com> writes:
> postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select
> x from (select x from i union all select y from j) b;
> x
> ---
> 1
> 2
> (2 rows)

> postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select
> max(x) from (select x from i union all select y from j) b;
> ERROR: could not find plan for CTE "i"

Yup, sure looks like a bug to me, especially since it seems to work as
expected before 9.5. No idea offhand what broke it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2016-12-13 16:22:37 Re: is this a known bug in 9.6?
Previous Message Tom Lane 2016-12-13 15:25:10 Re: When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?