Обсуждение: General Bug Report: backend closes with aggregate functions on views
============================================================================ 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: --------- --------------------------------------------------------------------------
Re: [BUGS] General Bug Report: backend closes with aggregate functions on views
От
Bruce Momjian
Дата:
> 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; This is a know problem. It is on the TODO list. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026