From: | Silvio Emanuel Barbosa de Macedo <smacedo(at)inescn(dot)pt> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | postgres Linux on i586 regression tests |
Date: | 1998-12-28 13:17:01 |
Message-ID: | Pine.GSO.3.96.981228125358.24543A-700000@newton.inescn.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
Postgres 6.4.1 (checked) / Linux 2.0.36 (RedHat 5.2) / glibc 2.0.7-19
Hi!
int2.out and int4.out on Linux differs from expected .out's.
I imagine lots of people have found this problem and ignored it, but,
anyway, I think that adding two files int2-linux_i386.out and
int2-linux_i386.out won't hurt.
The files and the diffs, the later, only for your convenience, follow
attached.
On the other hand, for float8 test, linux outputs a substancial different
result - instead of echoing error, it represents the problem with NaN (Not
a Number).
Is this important ? I mean... is this behaviour unpredicted by postgres ?
Thanks!
(I also get diffs on geometry tests.. but I haven't analysed them yet...)
*** float8.out Mon Dec 28 12:32:11 1998
--- float8.Linux.i586.out Mon Dec 28 12:33:31 1998
***************
*** 185,205 ****
QUERY: UPDATE FLOAT8_TBL
SET f1 = FLOAT8_TBL.f1 * '-1'
WHERE FLOAT8_TBL.f1 > '0.0';
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERROR: Bad float8 input format -- overflow
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! ERROR: pow() result is out of range
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
ERROR: can't take log of zero
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
ERROR: can't take log of a negative number
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! ERROR: exp() result is out of range
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
ERROR: float8div: divide by zero error
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
five|f1
----+---------------------
|0
|-34.84
--- 185,221 ----
QUERY: UPDATE FLOAT8_TBL
SET f1 = FLOAT8_TBL.f1 * '-1'
WHERE FLOAT8_TBL.f1 > '0.0';
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERROR: Bad float8 input format -- overflow
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! bad|?column?
! ---+--------
! |0
! |NaN
! |NaN
! |NaN
! |NaN
! (5 rows)
!
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
ERROR: can't take log of zero
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
ERROR: can't take log of a negative number
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! bad| ?column?
! ---+--------------------
! | 1
! |7.39912306090513e-16
! | 0
! | 0
! | 1
! (5 rows)
!
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
ERROR: float8div: divide by zero error
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
five|f1
----+---------------------
|0
|-34.84
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:smacedo(at)inescn(dot)pt
INESC - Porto - Grupo CAV
Pc da Republica, 93 R/C Tel:351 2 209 42 21
4000 PORTO PORTUGAL Fax:351 2 208 41 72
Attachment | Content-Type | Size |
---|---|---|
float8-linux_i386.out.diff | text/plain | 2.2 KB |
int4-linux_i386.out | text/plain | 6.4 KB |
int2-linux_i386.out | text/plain | 4.4 KB |
float8-linux_i386.out | text/plain | 8.1 KB |
int4-linux_i386.out.diff | text/plain | 1.5 KB |
int2-linux_i386.out.diff | text/plain | 1.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1998-12-28 16:09:04 | Port Bug Report: cache lookup failure |
Previous Message | Unprivileged user | 1998-12-28 12:00:19 | Port Bug Report: Remote connections never die |