[BUGS] Regression testing failure: float8...

2003-02-16 Thread Sean Chittenden 
Howdy.  Just a quick FYI, but I was running some regression tests on
HEAD and noticed that float8 is failing on FreeBSD 5.  FreeBSD 4 seems
to be fine.  Any suggestions on what I can poke at or where I should
look regarding this?  -sc

*** ./expected/float8-small-is-zero.out Tue Oct 22 13:01:15 2002
--- ./results/float8.outSun Feb 16 15:25:48 2003
***
*** 274,280 
--- 274,282 
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Input '-10e400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
+ ERROR:  Input '10e-400' is out of range for float8
  INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
+ ERROR:  Input '-10e-400' is out of range for float8
  -- maintain external table consistency across platforms
  -- delete all values and reinsert well-behaved ones
  DELETE FROM FLOAT8_TBL;

==

-- 
Sean Chittenden

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Regression testing failure: float8...

2003-02-16 Thread Tom Lane 
Sean Chittenden [EMAIL PROTECTED] writes:
 Actually, now that I think about it, since BSD hasn't changed it's
 handling of FPU errors in over 12 months now (no longer sends SIGFPE
 on FPU errors), and it used to pass less than a month ago, it looks
 like this is a perk of a recent gcc upgrade to 3.2.2.

I'd expect it to be a libc issue, not a compiler nor kernel thing.
What you've got is that strtod() is now returning ERANGE for an
underflowed input value, whereas before it did not.  It's hard to
believe that this would depend on which compiler you compiled Postgres
with.  (Maybe it could depend on which compiler you compiled libc
with, though?)

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html