regression.aix41

关系型数据库 Postgresql 6.5.2

  ----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-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"]                     
  (5 rows)
  
  QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
--- 98,107 ----
  five|f1                                                             |f1                                                             
  ----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       |["-infinity" "infinity"]                                       
!     |["Sun May 11 00:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["Sun May 11 00: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"]|["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"]                     
+     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  (5 rows)
  
  QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
***************
*** 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"]                       
          |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
!         |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]                                       
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]                                       
-         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]                                       
          |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]                                       
!         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["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"]
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
          |["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"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  (14 rows)
  
  QUERY: SELECT '' AS five, t1.f1
--- 110,129 ----
     ORDER BY interval1, interval2;
  fourteen|interval1                                                      |interval2                                                      
  --------+---------------------------------------------------------------+---------------------------------------------------------------
          |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
!         |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
!         |["-infinity" "infinity"]                                       |["Sun May 11 00:59:12 1947 PDT" "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"]
!         |["Sun May 11 00:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]                                       
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]                                       
          |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]                                       
!         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sun May 11 00:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
!         |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
!         |["Sun May 11 00: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"]
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
          |["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"]                       
!         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]                                       
  (14 rows)
  
  QUERY: SELECT '' AS five, t1.f1
***************
*** 133,139 ****
     ORDER BY t1.f1;
  five|f1                                                             
  ----+---------------------------------------------------------------
!     |["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"]
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)
--- 133,139 ----
     ORDER BY t1.f1;
  five|f1                                                             
  ----+---------------------------------------------------------------
!     |["Sun May 11 00: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"]
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  (3 rows)

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

*** expected/horology.out	Fri Jan  9 03:01:57 1998
--- results/horology.out	Thu Feb 26 10:25:04 1998
***************
*** 430,436 ****
    ORDER BY abstime;
  four|abstime                     |year|month|day|hour|minute|second
  ----+----------------------------+----+-----+---+----+------+------
!     |Sat May 10 23:59:12 1947 PST|1947|    5| 10|  23|    59|    12
      |epoch                       |1969|   12| 31|  16|     0|     0
      |Sun Jan 14 03:14:21 1973 PST|1973|    1| 14|   3|    14|    21
      |Mon May 01 00:30:30 1995 PDT|1995|    5|  1|   0|    30|    30
--- 430,436 ----
    ORDER BY abstime;
  four|abstime                     |year|month|day|hour|minute|second
  ----+----------------------------+----+-----+---+----+------+------
!     |Sun May 11 00:59:12 1947 PDT|1947|    5| 11|   0|    59|    12
      |epoch                       |1969|   12| 31|  16|     0|     0
      |Sun Jan 14 03:14:21 1973 PST|1973|    1| 14|   3|    14|    21
      |Mon May 01 00:30:30 1995 PDT|1995|    5|  1|   0|    30|    30
***************
*** 477,483 ****
    ORDER BY date;
  five|abstime                     |      date
  ----+----------------------------+----------
!     |Sat May 10 23:59:12 1947 PST|05-10-1947
      |epoch                       |01-01-1970
      |Sun Jan 14 03:14:21 1973 PST|01-14-1973
      |Mon May 01 00:30:30 1995 PDT|05-01-1995
--- 477,483 ----
    ORDER BY date;
  five|abstime                     |      date
  ----+----------------------------+----------
!     |Sun May 11 00:59:12 1947 PDT|05-11-1947
      |epoch                       |01-01-1970
      |Sun Jan 14 03:14:21 1973 PST|01-14-1973
      |Mon May 01 00:30:30 1995 PDT|05-01-1995
***************
*** 611,617 ****
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PST
       |invalid                     
  (8 rows)
  
--- 611,617 ----
       |current                     
       |infinity                    
       |-infinity                   
!      |Sun May 11 00:59:12 1947 PDT
       |invalid                     
  (8 rows)
  
***************
*** 692,698 ****
       |current               
       |infinity              
       |-infinity             
!      |1947-05-10 23:59:12-08
       |invalid               
  (8 rows)
  
--- 692,698 ----
       |current               
       |infinity              
       |-infinity             
!      |1947-05-11 00:59:12-07
       |invalid               
  (8 rows)
  
***************
*** 775,781 ****
       |current                   
       |infinity                  
       |-infinity                 
!      |05/10/1947 23:59:12.00 PST
       |invalid                   
  (8 rows)
  
--- 775,781 ----
       |current                   
       |infinity                  
       |-infinity                 
!      |05/11/1947 00:59:12.00 PDT
       |invalid                   
  (8 rows)
  
***************
*** 854,860 ****
             |Sat 01 Jan 17:32:01 2000 PST   
             |Sun 31 Dec 17:32:01 2000 PST   
             |Mon 01 Jan 17:32:01 2001 PST   
!            |Thu 13 Jun 00:00:00 1957 PDT   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
--- 854,860 ----
             |Sat 01 Jan 17:32:01 2000 PST   
             |Sun 31 Dec 17:32:01 2000 PST   
             |Mon 01 Jan 17:32:01 2001 PST   
!            |Thu 13 Jun 01:00:00 1957 PDT   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
***************
*** 866,872 ****
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat 10 May 23:59:12 1947 PST
       |invalid                     
  (8 rows)
  
--- 866,872 ----
       |current                     
       |infinity                    
       |-infinity                   
!      |Sun 11 May 00:59:12 1947 PDT
       |invalid                     
  (8 rows)
  
***************
*** 938,944 ****
             |2000-01-01 17:32:01-08   
             |2000-12-31 17:32:01-08   
             |2001-01-01 17:32:01-08   
!            |1957-06-13 00:00:00-07   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
--- 938,944 ----
             |2000-01-01 17:32:01-08   
             |2000-12-31 17:32:01-08   
             |2001-01-01 17:32:01-08   
!            |1957-06-13 01:00:00-07   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
***************
*** 950,956 ****
       |current               
       |infinity              
       |-infinity             
!      |1947-05-10 23:59:12-08
       |invalid               
  (8 rows)
  
--- 950,956 ----
       |current               
       |infinity              
       |-infinity             
!      |1947-05-11 00:59:12-07
       |invalid               
  (8 rows)
  
***************
*** 1022,1028 ****
             |01/01/2000 17:32:01.00 PST
             |31/12/2000 17:32:01.00 PST
             |01/01/2001 17:32:01.00 PST
!            |13/06/1957 00:00:00.00 PDT
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
--- 1022,1028 ----
             |01/01/2000 17:32:01.00 PST
             |31/12/2000 17:32:01.00 PST
             |01/01/2001 17:32:01.00 PST
!            |13/06/1957 01:00:00.00 PDT
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
***************
*** 1034,1040 ****
       |current