Skip site navigation (1) Skip section navigation (2)

postgres Linux on i586 regression tests

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 (view raw or flat)
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: int2-linux_i386.out.diff
Description: text/plain (1.4 KB)
Attachment: int4-linux_i386.out.diff
Description: text/plain (1.5 KB)
Attachment: float8-linux_i386.out
Description: text/plain (8.1 KB)
Attachment: int2-linux_i386.out
Description: text/plain (4.4 KB)
Attachment: int4-linux_i386.out
Description: text/plain (6.4 KB)
Attachment: float8-linux_i386.out.diff
Description: text/plain (2.2 KB)

pgsql-ports by date

Next:From: Unprivileged userDate: 1998-12-28 16:09:04
Subject: Port Bug Report: cache lookup failure
Previous:From: Unprivileged userDate: 1998-12-28 12:00:19
Subject: Port Bug Report: Remote connections never die

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group