regression.solaris-i386

关系型数据库 Postgresql 6.5.2

!    |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
!    |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))       
!    |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))           
!    |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))           
!    |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))           
!    |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))       
  (6 rows)
  
  QUERY: SELECT '' AS six, circle(f1, 50.0)
***************
*** 467,473 ****
     ORDER BY distance, circle, point using <<;
  twentyfour|circle        |point     |         distance
  ----------+--------------+----------+-----------------
!           |<(100,0),100> |(5.1,34.5)|0.976531926977964
            |<(1,2),3>     |(-3,4)    | 1.47213595499958
            |<(0,0),3>     |(-3,4)    |                2
            |<(100,0),100> |(-3,4)    | 3.07764064044151
--- 467,473 ----
     ORDER BY distance, circle, point using <<;
  twentyfour|circle        |point     |         distance
  ----------+--------------+----------+-----------------
!           |<(100,0),100> |(5.1,34.5)|0.976531926977965
            |<(1,2),3>     |(-3,4)    | 1.47213595499958
            |<(0,0),3>     |(-3,4)    |                2
            |<(100,0),100> |(-3,4)    | 3.07764064044151
***************
*** 482,488 ****
            |<(0,0),3>     |(10,10)   |  11.142135623731
            |<(1,3),5>     |(-5,-12)  | 11.1554944214035
            |<(1,2),3>     |(-5,-12)  | 12.2315462117278
!           |<(1,3),5>     |(5.1,34.5)| 26.7657047773224
            |<(1,2),3>     |(5.1,34.5)|  29.757594539282
            |<(0,0),3>     |(5.1,34.5)| 31.8749193547455
            |<(100,200),10>|(5.1,34.5)| 180.778038568384
--- 482,488 ----
            |<(0,0),3>     |(10,10)   |  11.142135623731
            |<(1,3),5>     |(-5,-12)  | 11.1554944214035
            |<(1,2),3>     |(-5,-12)  | 12.2315462117278
!           |<(1,3),5>     |(5.1,34.5)| 26.7657047773223
            |<(1,2),3>     |(5.1,34.5)|  29.757594539282
            |<(0,0),3>     |(5.1,34.5)| 31.8749193547455
            |<(100,200),10>|(5.1,34.5)| 180.778038568384

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

*** expected/abstime.out	Mon Oct 12 17:08:31 1998
--- results/abstime.out	Tue Oct 13 18:08:33 1998
***************
*** 22,28 ****
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PST
       |invalid                     
  (8 rows)
  
--- 22,28 ----
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PDT
       |invalid                     
  (8 rows)
  
***************
*** 35,41 ****
     |epoch                       
     |current                     
     |-infinity                   
!    |Sat May 10 23:59:12 1947 PST
  (6 rows)
  
  QUERY: SELECT '' AS six, ABSTIME_TBL.*
--- 35,41 ----
     |epoch                       
     |current                     
     |-infinity                   
!    |Sat May 10 23:59:12 1947 PDT
  (6 rows)
  
  QUERY: SELECT '' AS six, ABSTIME_TBL.*
***************
*** 47,53 ****
     |epoch                       
     |current                     
     |infinity                    
!    |Sat May 10 23:59:12 1947 PST
  (6 rows)
  
  QUERY: SELECT '' AS six, ABSTIME_TBL.*
--- 47,53 ----
     |epoch                       
     |current                     
     |infinity                    
!    |Sat May 10 23:59:12 1947 PDT
  (6 rows)
  
  QUERY: SELECT '' AS six, ABSTIME_TBL.*
***************
*** 75,81 ****
  -----+----------------------------
       |epoch                       
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PST
  (3 rows)
  
  QUERY: SELECT '' AS four, ABSTIME_TBL.*
--- 75,81 ----
  -----+----------------------------
       |epoch                       
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PDT
  (3 rows)
  
  QUERY: SELECT '' AS four, ABSTIME_TBL.*
***************
*** 85,91 ****
      |Sun Jan 14 03:14:21 1973 PST
      |epoch                       
      |-infinity                   
!     |Sat May 10 23:59:12 1947 PST
  (4 rows)
  
  QUERY: SELECT '' AS four, ABSTIME_TBL.*
--- 85,91 ----
      |Sun Jan 14 03:14:21 1973 PST
      |epoch                       
      |-infinity                   
!     |Sat May 10 23:59:12 1947 PDT
  (4 rows)
  
  QUERY: SELECT '' AS four, ABSTIME_TBL.*
***************
*** 106,112 ****
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PST
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
--- 106,112 ----
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PDT
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
***************
*** 116,122 ****
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PST
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
--- 116,122 ----
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PDT
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
***************
*** 126,132 ****
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PST
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
--- 126,132 ----
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PDT
  (3 rows)
  
  QUERY: SELECT '' AS three, ABSTIME_TBL.*
***************
*** 136,142 ****
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PST
  (3 rows)
  
  QUERY: SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
--- 136,142 ----
  -----+----------------------------
       |Sun Jan 14 03:14:21 1973 PST
       |epoch                       
!      |Sat May 10 23:59:12 1947 PDT
  (3 rows)
  
  QUERY: SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
***************
*** 145,155 ****
     ORDER BY abstime, reltime;
  ten|abstime                     |reltime      
  ---+----------------------------+-------------
!    |Sat May 10 23:59:12 1947 PST|@ 14 secs ago
!    |Sat May 10 23:59:12 1947 PST|@ 1 min      
!    |Sat May 10 23:59:12 1947 PST|@ 5 hours    
!    |Sat May 10 23:59:12 1947 PST|@ 10 days    
!    |Sat May 10 23:59:12 1947 PST|@ 3 mons     
     |epoch                       |@ 14 secs ago
     |epoch                       |@ 1 min      
     |epoch                       |@ 5 hours    
--- 145,155 ----
     ORDER BY abstime, reltime;
  ten|abstime                     |reltime      
  ---+----------------------------+-------------
!    |Sat May 10 23:59:12 1947 PDT|@ 14 secs ago
!    |Sat May 10 23:59:12 1947 PDT|@ 1 min      
!    |Sat May 10 23:59:12 1947 PDT|@ 5 hours    
!    |Sat May 10 23:59:12 1947 PDT|@ 10 days    
!    |Sat May 10 23:59:12 1947 PDT|@ 3 mons     
     |epoch                       |@ 14 secs ago
     |epoch                       |@ 1 min      
     |epoch                       |@ 5 hours    

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

*** expected/tinterval.out	Mon Oct 12 17:09:13 1998
--- results/tinterval.out	Tue Oct 13 18:08:34 1998
***************
*** 19,25 ****
  five|f1                                                             
  ----+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       
!     |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
      |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
--- 19,25 ----
  five|f1                                                             
  ----+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       
!     |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
      |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
***************
*** 38,44 ****
     WHERE t.f1 #<> '@ 1 months';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
--- 38,44 ----
     WHERE t.f1 #<> '@ 1 months';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
***************
*** 63,69 ****
     WHERE t.f1 #> '@ 1 year';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
--- 63,69 ----
     WHERE t.f1 #> '@ 1 year';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
***************
*** 73,79 ****
     WHERE t.f1 #>= '@ 3 years';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
--- 73,79 ----
     WHERE t.f1 #>= '@ 3 years';
  three|f1                                                             
  -----+---------------------------------------------------------------
!      |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
***************
*** 98,104 ****
  five|f1                                                             |f1                                                             
  ----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       |["-infinity" "infinity"]                                       
!     |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
      |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
--- 98,104 ----
  five|f1                                                             |f1                                                             
  ----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       |["-infinity" "infinity"]                                       
!     |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
      |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
***************
*** 110,129 ****
     ORDER BY interval1, interval2;
  fourteen|interval1                                                      |interval2                                                      
  --------+---------------------------------------------------------------+---------------------------------------------------------------
!         |["-infinity" "infinity"]                                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
          |["-infinity" "infinity"]                                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
          |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]