regression.freebsd

关系型数据库 Postgresql 6.5.2

!     |0                   
!     |0                   
! (7 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:  floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero
  QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! ERROR:  Bad float8 input format -- overflow
  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,216 ****
  ---+--------------------
     |                   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
--- 227,238 ----
  ---+--------------------
     |                   1
     |7.39912306090513e-16
+    |                   1
+    |                   1
     |                   0
     |                   0
     |                   1
! (7 rows)
  
  QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
  ERROR:  float8div: divide by zero error
***************
*** 219,226 ****
  ----+---------------------
      |0                    
      |-34.84               
      |-1004.3              
      |-1.2345678901234e+200
      |-1.2345678901234e-200
! (5 rows)
  
--- 241,250 ----
  ----+---------------------
      |0                    
      |-34.84               
+     |0                    
+     |0                    
      |-1004.3              
      |-1.2345678901234e+200
      |-1.2345678901234e-200
! (7 rows)
  

----------------------

*** expected/numerology.out	Thu Mar 19 00:49:56 1998
--- results/numerology.out	Sun Mar 22 15:36:25 1998
***************
*** 23,28 ****
--- 23,31 ----
  QUERY: INSERT INTO TEMP_INT4 (f1)
    SELECT int4(f1) FROM FLOAT8_TBL
    WHERE (f1 > -2147483647) AND (f1 < 2147483647);
+ ERROR:  There is no operator '>' for types 'float8' and 'int4'
+ 	You will either have to retype this query using an explicit cast,
+ 	or you will have to define the operator using CREATE OPERATOR
  QUERY: INSERT INTO TEMP_INT4 (f1)
    SELECT int4(f1) FROM INT2_TBL;
  QUERY: SELECT '' AS nine, f1 FROM TEMP_INT4
***************
*** 31,44 ****
  ----+------
      |-32767
      | -1234
-     | -1004
-     |   -35
-     |     0
-     |     0
      |     0
      |  1234
      | 32767
! (9 rows)
  
  QUERY: CREATE TABLE TEMP_INT2 (f1 INT2);
  QUERY: INSERT INTO TEMP_INT2 (f1)
--- 34,43 ----
  ----+------
      |-32767
      | -1234
      |     0
      |  1234
      | 32767
! (5 rows)
  
  QUERY: CREATE TABLE TEMP_INT2 (f1 INT2);
  QUERY: INSERT INTO TEMP_INT2 (f1)
***************
*** 56,62 ****
      |    0
      |    0
      |    0
! (5 rows)
  
  QUERY: CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);
  QUERY: INSERT INTO TEMP_GROUP
--- 55,63 ----
      |    0
      |    0
      |    0
!     |    0
!     |    0
! (7 rows)
  
  QUERY: CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);
  QUERY: INSERT INTO TEMP_GROUP

----------------------

*** expected/geometry.out	Thu Mar 19 00:49:41 1998
--- results/geometry.out	Sun Mar 22 15:36:29 1998
***************
*** 100,106 ****
        |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
        |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
        |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
!       |(0,0)     |[(0,0),(6,6)]                |(-0,0)                              
        |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
        |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
        |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
--- 100,106 ----
        |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
        |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
        |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
!       |(0,0)     |[(0,0),(6,6)]                |(0,0)                               
        |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
        |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
        |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
***************
*** 113,119 ****
        |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
        |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
        |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
!       |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
        |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
        |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
        |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
--- 113,119 ----
        |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
        |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
        |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
!       |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
        |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
        |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
        |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
***************
*** 130,140 ****
  six|box                                                                       
  ---+--------------------------------------------------------------------------
     |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) 
!    |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) 
!    |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
!    |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643)
     |(107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)   
!    |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)  
  (6 rows)
  
  QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation
--- 130,140 ----
  six|box                                                                       
  ---+--------------------------------------------------------------------------
     |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) 
!    |(71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547) 
!    |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
!    |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
     |(107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)   
!    |(170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)  
  (6 rows)
  
  QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation
***************
*** 205,215 ****
            |(0,0),(0,0)                
            |(0,0),(0,0)                
            |(0,0),(0,0)                
!           |(-0,0),(-20,-20)           
            |(-10,-10),(-30,-30)        
            |(-25,-25),(-25,-35)        
            |(-30,-30),(-30,-30)        
!           |(-0,2),(-14,0)             
            |(-7,3),(-21,1)             
            |(-17.5,2.5),(-21.5,-0.5)   
            |(-21,3),(-21,3)            
--- 205,215 ----
            |(0,0),(0,0)                
            |(0,0),(0,0)                
            |(0,0),(0,0)                
!           |(0,0),(-20,-20)            
            |(-10,-10),(-30,-30)        
            |(-25,-25),(-25,-35)        
            |(-30,-30),(-30,-30)        
!           |(0,2),(-14,0)              
            |(-7,3),(-21,1)             
            |(-17.5,2.5),(-21.5,-0.5)   
            |(-21,3),(-21,3)            
***************
*** 217,223 ****
            |(-29.4,118.8),(-88.2,39.6) 
            |(-73.5,104.1),(-108,99)    
            |(-88.2,118.8),(-88.2,118.8)
!           |(14,-0),(0,-34)            
            |(21,-17),(7,-51)           
            |(29.5,-42.5),(17.5,-47.5)  
            |(21,-51),(21,-51)          
--- 217,223 ----
            |(-29.4,118.8),(-88.2,39.6) 
            |(-73.5,104.1),(-108,99)    
            |(-88.2,118.8),(-88.2,118.8)
!           |(14,0),(0,-34)