Обсуждение: bug in 6.5.3...

I looked in the "TODO" list and didn't find any mention of
avg() or relevant items regarding aggregates so here's my
bug du jour:

acs=> create table foo(p numeric(9,2));
CREATE
acs=> select avg(p) from foo;
ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
scale 1723
acs=> 
acs=> insert into foo values(3);
INSERT 1014409 1
acs=> select avg(p) from foo;
ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
scale 1723
acs=> select p from foo;  p
----
3.00
(1 row)

acs=> select max(p) from foo;max
----
3.00
(1 row)



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 

Don Baccus <dhogaza@pacifier.com> writes:
> I looked in the "TODO" list and didn't find any mention of
> avg() or relevant items regarding aggregates so here's my
> bug du jour:

> acs=> create table foo(p numeric(9,2));
> CREATE
> acs=> select avg(p) from foo;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
> scale 1723
> acs=> 
> acs=> insert into foo values(3);
> INSERT 1014409 1
> acs=> select avg(p) from foo;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
> scale 1723

That's a known bug I believe (Jan, are you paying attention?).  It seems
to be platform-dependent --- in current sources, I see no failure on an
HPUX box, but a Linux box fails with
ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 2077 scale 22808
Maybe a big-vs-little-endian kind of problem?
        regards, tom lane