bug in numeric log() on 7.1, 7.2.2, 7.2.3

From: dmarin <dmarin(at)uclink(dot)berkeley(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug in numeric log() on 7.1, 7.2.2, 7.2.3
Date: 2003-03-10 06:19:26
Message-ID: 3E73ECFA@bearmail.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

This query never returns:

select log(93094::numeric/92908::numeric);

If I type it in to psql on the three different systems I'm running postgresql
on, the query never returns, I can't cancel it (if I hit ctl-C psql says
"cancel request sent" but I don't get the prompt back), and postmaster (viewed

in top) uses all the idle CPU time. I can still do other queries and such, but

I can't shut down postmaster except with SIGQUIT or SIGKILL (actually, only
SIGKILL works on the solaris system, below).

The problem appears to exist with numeric log. I don't have problems with, for

instance, log(93094::float/92908::float)

The three systems:

(output of: echo "select version();" | psql template1; uname -a)

version
------------------------------------------------------------------------------
----------------------
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
(Mandrake Linux 9.0 3.2-1mdk)
(1 row)

Linux gohma.i 2.4.19-16mdk #1 Fri Sep 20 18:15:05 CEST 2002 i686 unknown
unknown GNU/Linux

version
-------------------------------------------------------------
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

Linux karma 2.4.18-7mdksmp #1 SMP Sat Mar 16 21:49:18 CET 2002 i686 unknown

(this is a somewhat upgraded Mandrake 8.1 system; I think I compiled
postgresql myself)

version
------------------------------------------------------------------
PostgreSQL 7.2.3 on sparc-sun-solaris2.8, compiled by GCC 2.95.2
(1 row)

SunOS boojum.CS.Berkeley.EDU 5.8 Generic_108528-18 sun4u sparc SUNW,Ultra-5_10


(also compiled from source)

-Dave

P.S. Incidentally, on the solaris system, I also can't use pg_dump at all; no
matter what database I try to dump, I get a bus error:

[dmarin(at)boojum]$ pg_dump template1;
Bus Error

Is this a known problem, or would you like more information?)

P.P.S. 93094 (the first number in the deadly log expression) is the zip code
of Simi Valley, CA. First the Rodney King riots, now this! :P

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-03-10 10:07:03 Bug #908: Can not INSERT Cyrilic characters when use UNICODE database
Previous Message pgsql-bugs 2003-03-10 00:05:08 pgsql-bugs G~~