Re: BUG #15053: SIGSEGV - While executing query with cube agregator

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> the following postgres crash was generated during the execution of this
> query:

> select
> freeswitch_bug_events.created_at::date,
> freeswitch_nodes."name",
> tenants."name",
> count(*) filter(where freeswitch_bug_events.event = 'call received'),
> count(*) filter(where freeswitch_bug_events.event = 'status changed')
> from dev.freeswitch_bug_events
> join public.tenants on freeswitch_bug_events.tenant = tenants.id
> join public.freeswitch_nodes on freeswitch_bug_events.node =
> freeswitch_nodes.id
> group by
> cube (freeswitch_bug_events.created_at::date, freeswitch_nodes."name",
> tenants."name" )

Hmm, well, first please update to something newer than 9.6.3, to see if
the problem is already resolved. (9.6.7 is being released this week.)

If not, please see if you can extract a self-contained test case. That
stack trace is not really enough information to fix it.

regards, tom lane