Re: Wrong results with grouping sets

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Wrong results with grouping sets
Дата
Msg-id CAApHDvp2_yht8uPLyWO-kVGWZhYvx5zjGfSrg4fBQ9fsC13V0g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Wrong results with grouping sets  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: Wrong results with grouping sets
Список pgsql-hackers
On Tue, 10 Sept 2024 at 16:04, Richard Guo <guofenglinux@gmail.com> wrote:
> I went ahead and pushed 0001 and 0002, and am now waiting for the
> upcoming bug reports.

Here's one:

create table a(a int);
explain select * from a where exists(Select 1 from a a2 where a.a =
a2.a  group by a);
CREATE TABLE
server closed the connection unexpectedly

TRAP: failed Assert("parse->hasGroupRTE"), File:
"../src/backend/optimizer/plan/planner.c", Line: 794, PID: 107765

David



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