Re: [GENERAL] is this a known bug in 9.6?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] is this a known bug in 9.6?
Дата
Msg-id 31684.1481643109@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] is this a known bug in 9.6?  (Torsten Förtsch <tfoertsch123@gmail.com>)
Ответы Re: [GENERAL] is this a known bug in 9.6?
Re: [GENERAL] is this a known bug in 9.6?
Re: [GENERAL] is this a known bug in 9.6?
Список pgsql-general
=?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: [GENERAL] is this a known bug in 9.6?