regression.freebsd

关系型数据库 Postgresql 6.5.2

*** expected/float8.out	Thu Mar 19 00:49:38 1998
--- results/float8.out	Sun Mar 22 15:36:24 1998
***************
*** 9,17 ****
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  ERROR:  Bad float8 input format '-10e400'
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
- ERROR:  Bad float8 input format '10e-400'
  QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
- ERROR:  Bad float8 input format '-10e-400'
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  five|f1                  
  ----+--------------------
--- 9,15 ----
***************
*** 20,26 ****
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200
! (5 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
  four|f1                  
--- 18,26 ----
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200
!     |0                   
!     |0                   
! (7 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
  four|f1                  
***************
*** 29,35 ****
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200
! (4 rows)
  
  QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
  one|    f1
--- 29,37 ----
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200
!     |0                   
!     |0                   
! (6 rows)
  
  QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
  one|    f1
***************
*** 43,49 ****
       |                   0
       |              -34.84
       |1.2345678901234e-200
! (3 rows)
  
  QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE  f.f1 < '1004.3';
  three|                  f1
--- 45,53 ----
       |                   0
       |              -34.84
       |1.2345678901234e-200
!      |                   0
!      |                   0
! (5 rows)
  
  QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE  f.f1 < '1004.3';
  three|                  f1
***************
*** 51,57 ****
       |                   0
       |              -34.84
       |1.2345678901234e-200
! (3 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
  four|                  f1
--- 55,63 ----
       |                   0
       |              -34.84
       |1.2345678901234e-200
!      |                   0
!      |                   0
! (5 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
  four|                  f1
***************
*** 60,66 ****
      |              1004.3
      |              -34.84
      |1.2345678901234e-200
! (4 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE  f.f1 <= '1004.3';
  four|                  f1
--- 66,74 ----
      |              1004.3
      |              -34.84
      |1.2345678901234e-200
!     |                   0
!     |                   0
! (6 rows)
  
  QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE  f.f1 <= '1004.3';
  four|                  f1
***************
*** 69,75 ****
      |              1004.3
      |              -34.84
      |1.2345678901234e-200
! (4 rows)
  
  QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
     FROM FLOAT8_TBL f
--- 77,85 ----
      |              1004.3
      |              -34.84
      |1.2345678901234e-200
!     |                   0
!     |                   0
! (6 rows)
  
  QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
     FROM FLOAT8_TBL f
***************
*** 127,133 ****
      |-34.84              |34.84               
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|1.2345678901234e-200
! (5 rows)
  
  QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
     FROM FLOAT8_TBL f;
--- 137,145 ----
      |-34.84              |34.84               
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|1.2345678901234e-200
!     |0                   |0                   
!     |0                   |0                   
! (7 rows)
  
  QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
     FROM FLOAT8_TBL f;
***************
*** 138,144 ****
      |-34.84              |-34                 
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|0                   
! (5 rows)
  
  QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
     FROM FLOAT8_TBL f;
--- 150,158 ----
      |-34.84              |-34                 
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|0                   
!     |0                   |0                   
!     |0                   |0                   
! (7 rows)
  
  QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
     FROM FLOAT8_TBL f;
***************
*** 149,155 ****
      |-34.84              |-35                 
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|0                   
! (5 rows)
  
  QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
     FROM FLOAT8_TBL f
--- 163,171 ----
      |-34.84              |-35                 
      |1.2345678901234e+200|1.2345678901234e+200
      |1.2345678901234e-200|0                   
!     |0                   |0                   
!     |0                   |0                   
! (7 rows)
  
  QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
     FROM FLOAT8_TBL f
***************
*** 179,185 ****
      |-34.84              |-3.26607421344208   
      |1.2345678901234e+200|4.97933859234765e+66
      |1.2345678901234e-200|2.3112042409018e-67 
! (5 rows)
  
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  five|f1                  
--- 195,203 ----
      |-34.84              |-3.26607421344208   
      |1.2345678901234e+200|4.97933859234765e+66
      |1.2345678901234e-200|2.3112042409018e-67 
!     |0                   |0                   
!     |0                   |0                   
! (7 rows)
  
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  five|f1                  
***************
*** 189,203 ****
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200
! (5 rows)
  
  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' ;
--- 207,223 ----
      |-34.84              
      |1.2345678901234e+200
      |1.2345678901234e-200