Re: [SQL] MAX() of 0 records.

From: Paul McGarry <paulm(at)opentec(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [SQL] MAX() of 0 records.
Date: 2000-07-07 05:34:13
Message-ID: 39656BD5.801BDEDC@opentec.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-sql

Tom Lane wrote:

> This seems like a backend bug to me, but being an overworked hacker
> I'm too lazy to try to reconstruct the scenario from your sketch.
> Could I trouble you to submit a formal bug report with a specific,
> hopefully compact script that triggers the problem?

I've attached it here, along with the output I see. I am running 7.0.2
and the problem occurs on both my x86 Linux and Sparc Solaris
installations.

In addition to the output attached the postmaster console adds:
====
DEBUG: Last error occured while executing PL/pgSQL function
setentrystats
DEBUG: line 4 at SQL statement
====

Thanks,

--
Paul McGarry mailto:paulm(at)opentec(dot)com(dot)au
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd http://www.iebusiness.com.au
6 Lyon Park Road Phone: (02) 9878 1744
North Ryde NSW 2113 Fax: (02) 9878 1755

Attachment Content-Type Size
ctidnulltest.out application/x-unknown-content-type-out_auto_file 706 bytes
ctidnulltest.sql application/x-unknown-content-type-sql_auto_file 1.5 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matthew Altus 2000-07-07 06:53:30 ps_status.h on FreeBSD 4.0 problems and fix
Previous Message Tom Lane 2000-07-07 03:29:42 Re: MAX() of 0 records.

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-07-07 05:58:53 Re: DateStyle (was Re: Per-database/schema settings)
Previous Message Tom Lane 2000-07-07 05:30:40 Re: lztext and compression ratios...

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-07 07:06:03 Re: [SQL] MAX() of 0 records.
Previous Message Tom Lane 2000-07-07 05:30:40 Re: lztext and compression ratios...