Horton

Thread

  1. General Bug Report: backend closes with aggregate functions on views

    Unprivileged user <nobody> — 1999-03-17T05:33:03Z

    ============================================================================
                        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, doing so 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:
---------


--------------------------------------------------------------------------