Re: Crash with a CUBE query on 9.6

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Crash with a CUBE query on 9.6
Date: 2016-12-27 22:47:52
Message-ID: CAKJS1f8nqAMcat+db1cYNcjmtHUGP1nBVu8-9o+A-fC+hEeOhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 20 December 2016 at 20:24, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
> postgres=# select avg(distinct one::numeric), sum(distinct one::numeric)
> from (values(1),(3),(1)) t(one);
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
>
> Fixed the expected output, and committed. Thanks!

Many thanks for fixing this Heikki, and Tom for the investigation.

Sorry for not chipping in or helping. It was summer holiday time down
this end of the planet.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-12-27 23:43:25 Re: pg_receivexlog creating holes in WAL (HEAD only)
Previous Message Tom Lane 2016-12-27 20:00:43 Re: BUG #14479: Casting non-constant values to INTERVAL DAY TO MINUTE doesn't truncate the seconds field