regression.aix41

关系型数据库 Postgresql 6.5.2

       |infinity                  
       |-infinity                 
!      |10/05/1947 23:59:12.00 PST
       |invalid                   
  (8 rows)
  
--- 1034,1040 ----
       |current                   
       |infinity                  
       |-infinity                 
!      |11/05/1947 00:59:12.00 PDT
       |invalid                   
  (8 rows)
  
***************
*** 1109,1115 ****
           |Sat Jan 01 17:32:01 2000 PST   
           |Sun Dec 31 17:32:01 2000 PST   
           |Mon Jan 01 17:32:01 2001 PST   
!          |Thu Jun 13 00:00:00 1957 PDT   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
--- 1109,1115 ----
           |Sat Jan 01 17:32:01 2000 PST   
           |Sun Dec 31 17:32:01 2000 PST   
           |Mon Jan 01 17:32:01 2001 PST   
!          |Thu Jun 13 01:00:00 1957 PDT   
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
***************
*** 1121,1127 ****
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat May 10 23:59:12 1947 PST
       |invalid                     
  (8 rows)
  
--- 1121,1127 ----
       |current                     
       |infinity                    
       |-infinity                   
!      |Sun May 11 00:59:12 1947 PDT
       |invalid                     
  (8 rows)
  
***************
*** 1191,1197 ****
           |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 us_iso FROM ABSTIME_TBL;
--- 1191,1197 ----
           |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 us_iso FROM ABSTIME_TBL;
***************
*** 1203,1209 ****
       |current               
       |infinity              
       |-infinity             
!      |1947-05-10 23:59:12-08
       |invalid               
  (8 rows)
  
--- 1203,1209 ----
       |current               
       |infinity              
       |-infinity             
!      |1947-05-11 00:59:12-07
       |invalid               
  (8 rows)
  
***************
*** 1275,1281 ****
           |01/01/2000 17:32:01.00 PST
           |12/31/2000 17:32:01.00 PST
           |01/01/2001 17:32:01.00 PST
!          |06/13/1957 00:00:00.00 PDT
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
--- 1275,1281 ----
           |01/01/2000 17:32:01.00 PST
           |12/31/2000 17:32:01.00 PST
           |01/01/2001 17:32:01.00 PST
!          |06/13/1957 01:00:00.00 PDT
  (63 rows)
  
  QUERY: SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
***************
*** 1287,1293 ****
       |current                   
       |infinity                  
       |-infinity                 
!      |05/10/1947 23:59:12.00 PST
       |invalid                   
  (8 rows)
  
--- 1287,1293 ----
       |current                   
       |infinity                  
       |-infinity                 
!      |05/11/1947 00:59:12.00 PDT
       |invalid                   
  (8 rows)
  
***************
*** 1366,1373 ****
             |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   
!            |Thu 13 Jun 00:00:00 1957 PDT   
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
--- 1366,1373 ----
             |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   
!            |Thu 13 Jun 01:00:00 1957 PDT   
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
***************
*** 1379,1385 ****
       |current                     
       |infinity                    
       |-infinity                   
!      |Sat 10 May 23:59:12 1947 PST
       |invalid                     
  (8 rows)
  
--- 1379,1385 ----
       |current                     
       |infinity                    
       |-infinity                   
!      |Sun 11 May 00:59:12 1947 PDT
       |invalid                     
  (8 rows)
  
***************
*** 1451,1458 ****
             |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   
!            |1957-06-13 00:00:00-07   
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
--- 1451,1458 ----
             |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   
!            |1957-06-13 01:00:00-07   
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
***************
*** 1464,1470 ****
       |current               
       |infinity              
       |-infinity             
!      |1947-05-10 23:59:12-08
       |invalid               
  (8 rows)
  
--- 1464,1470 ----
       |current               
       |infinity              
       |-infinity             
!      |1947-05-11 00:59:12-07
       |invalid               
  (8 rows)
  
***************
*** 1536,1543 ****
             |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
!            |13/06/1957 00:00:00.00 PDT
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
--- 1536,1543 ----
             |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
!            |13/06/1957 01:00:00.00 PDT
  (64 rows)
  
  QUERY: SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
***************
*** 1549,1555 ****
       |current                   
       |infinity                  
       |-infinity                 
!      |10/05/1947 23:59:12.00 PST
       |invalid                   
  (8 rows)
  
--- 1549,1555 ----
       |current                   
       |infinity                  
       |-infinity                 
!      |11/05/1947 00:59:12.00 PDT
       |invalid                   
  (8 rows)
  

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

*** expected/random.out	Tue Apr 29 10:23:40 1997
--- results/random.out	Thu Feb 26 10:31:25 1998
***************
*** 7,18 ****
  QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  count
  -----
!    92
  (1 row)
  
  QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  count
  -----
!    98
  (1 row)
  
--- 7,18 ----
  QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  count
  -----
!    95
  (1 row)
  
  QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  count
  -----
!    88
  (1 row)