BUG #16255: No respect for 'not materialized' on CTEs with group by

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16255: No respect for 'not materialized' on CTEs with group by
Дата
Msg-id 16255-e18a59c1ef606bbc@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16255: No respect for 'not materialized' on CTEs with group by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      16255
Logged by:          Robert Ford
Email address:      robfordww@gmail.com
PostgreSQL version: 12.1
Operating system:   Windows
Description:

I have an simple CTE expression with group by and a string_aggr() function,
and Postgresql seems to materialize it anyhow, even if 'not materialized' is
instructed. I can't see that this is documented behaviour.

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: ERROR: subtransaction logged without previous top-level txn record
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16255: No respect for 'not materialized' on CTEs with group by