Re: [SQL] Postres falls down on "having"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Mamin <pm(at)sky(dot)ru>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Postres falls down on "having"
Date: 1999-08-10 14:55:32
Message-ID: 5141.934296932@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Paul Mamin <pm(at)sky(dot)ru> writes:
> And when result is not empty - everything's Ok.
> But when it's empty then [ backend crashes ]

I can reproduce this bug with the current development sources.
Will look into it. A quick look at a backtrace suggests that
the problem is triggered by the "sum(int8(inb))>=maxinb" part
of the HAVING clause. You might be able to work around it if
you can use int4 or float instead of int8 ...

regards, tom lane

Browse pgsql-sql by date

  From Date Subject
Next Message David Ouellet 1999-08-10 15:16:07 Re: [SQL] Question about arrays
Previous Message Giovanni B. Stefanoni 1999-08-10 14:21:25 rpm 6.5 requires libcurses.so.4?