============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Richi Plana
Your email address : richip@mozcom.com
Category : runtime: back-end: SQL
Severity : serious
Summary: backend closes with aggregate functions on views
System Configuration
--------------------
Operating System : SMP Intel/Linux 2.2.0, Sparc/Solaris 2.6
PostgreSQL version : 6.4.2
Compiler used : pgcc-1.1.1 and egcs-1 (for Sparc)
Hardware:
---------
1) SparcStation 20 (50MHz processor), 300+MB RAM, SCSI harddisks
2) Dual Pentium-II 400 (N440BX-based motherboard), 512MB RAM, SCSI harddisk
Versions of other tools:
------------------------
flex-2.5.4, gmake
--------------------------------------------------------------------------
Problem Description:
--------------------
It seems the pg backend disconnects a connection when a user performs an aggregate function on a view. In one instance,
doingso killed the backend.
I can't seem to duplicate killing the backend, but is this proper behavior for the backend?
--------------------------------------------------------------------------
Test Case:
----------
create table a (b char(20) not null, c char(10) not null, d int, primary key (b, c));
create view d as select b,sum(d) from a group by b;
select max(sum) from d;
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------