pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Paul Mamin <pm@sky.ru>
To: pgsql-sql@postgreSQL.org
Subject: Postres falls down on "having"
Date: Tue, 10 Aug 1999 11:35:11 +0600
Message-ID: <13482.990810@sky.ru> (raw)

Please, help me. I have Postgres 6.5 on Linux and found some bug.

=====================================
Table definitions:

>create sequence serialseq;
>
>create table calls
>(numcall integer default nextval('serialseq') not null primary key,
>uzer integer not null,
>inter integer not null,
>calltime abstime not null,
>calldur reltime not null,
>inb integer not null,
>outb integer not null,
>callprice integer);
>
>create index uzer_udx
>on calls
>(uzer);
>
>create index inter_udx
>on calls
>(inter);
>
>create index calltime_udx
>on calls
>(calltime)


>create table pppdisab
>(uzer integer primary key,
>timedisab abstime,
>maxprice integer,
>maxdur integer,
>maxinb int8);
>
>create index timedisab_idx on pppdisab (timedisab)

=====================================

And then I make some query (time is european):

>select calls.uzer
> from calls,pppdisab
> where
>   calltime>='01/08/1999'
>   and calls.uzer=pppdisab.uzer
>   and pppdisab.timedisab is NULL
> group by calls.uzer,maxprice,maxdur,maxinb
> having
>   sum((int(calldur)+59)/60)>=maxdur
>   or sum(callprice)>=maxprice
>   or sum(int8(inb))>=maxinb

=====================================

And when result is not empty - everything's Ok.
But when it's empty then the main postmaster crashes with message to
stdout like this:

>pq_recvbuf: unexpected EOF on client connection
>pq_flush: send() failed: Broken pipe
>pq_recvbuf: recv() failed: Connection reset by peer
>pq_recvbuf: unexpected EOF on client connection
>NOTICE:  Message from PostgreSQL backend:
>        The Postmaster has informed me that some other backend died abnormally a
>nd possibly corrupted shared memory.
>        I have rolled back the current transaction and am going to terminate you
>r database system connection and exit.
>        Please reconnect to the database system and repeat your query.
>NOTICE:  Message from PostgreSQL backend:
>        The Postmaster has informed me that some other backend died abnormally a
>nd possibly corrupted shared memory.
>        I have rolled back the current transaction and am going to terminate you
>r database system connection and exit.
>        Please reconnect to the database system and repeat your query.

... and all backends fall down :(

=====================================

At the same time, when I make similar query, but without "having",
all works fine in any cases:

>select calls.uzer,sum((int(calldur)+59)/60),maxdur,sum(callprice),maxprice,sum(int8(inb)),maxinb
> from calls,pppdisab
> where
>   calltime>='01/08/1999'
>   and calls.uzer=pppdisab.uzer
>   and pppdisab.timedisab is NULL
> group by calls.uzer,maxprice,maxdur,maxinb

=====================================

What's the matter?

Best regards,
 Paul                          mailto:pm@sky.ru





view thread (2+ messages)  latest in thread

Message-ID: <13482.990810@sky.ru>
Permalink:  ../13482.990810@sky.ru/
Also on:    postgresql.org/message-id/13482.990810@sky.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: pm@sky.ru
  Subject: Re: Postres falls down on "having"
  In-Reply-To: <13482.990810@sky.ru>
  References: <13482.990810@sky.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox