Horton

regression.diffs

text/x-diff

Download
Filename: regression.diffs
Type: text/x-diff
Part: 0
Message: tzdata2017a breaks timestamptz regression test

Patch

Format: context
File+−
/home/postgres/pgsql/src/test/regress/results/timestamptz.out 46 46 
*** /home/postgres/pgsql/src/test/regress/expected/timestamptz.out	Mon Jan 30 17:03:46 2017
--- /home/postgres/pgsql/src/test/regress/results/timestamptz.out	Thu Mar  9 13:35:41 2017
***************
*** 1778,1796 ****
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 08:15:55.33 1973 CLT
  (1 row)
  
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 02:15:55.33 1973 CLT
  (1 row)
  
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '-2');
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 06:15:55.33 1973 CLT
  (1 row)
  
  WITH tzs (tz) AS (VALUES
--- 1778,1796 ----
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 08:15:55.33 1973 -04
  (1 row)
  
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 02:15:55.33 1973 -04
  (1 row)
  
  SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '-2');
          make_timestamptz         
  ---------------------------------
!  Sun Jul 15 06:15:55.33 1973 -04
  (1 row)
  
  WITH tzs (tz) AS (VALUES
***************
*** 1799,1821 ****
      ('+10:00:1'), ('+10:00:01'),
      ('+10:00:10'))
       SELECT make_timestamptz(2010, 2, 27, 3, 45, 00, tz), tz FROM tzs;
!        make_timestamptz        |    tz     
! -------------------------------+-----------
!  Fri Feb 26 23:45:00 2010 CLST | +1
!  Fri Feb 26 23:45:00 2010 CLST | +1:
!  Fri Feb 26 23:45:00 2010 CLST | +1:0
!  Fri Feb 26 23:45:00 2010 CLST | +100
!  Fri Feb 26 23:45:00 2010 CLST | +1:00
!  Fri Feb 26 23:45:00 2010 CLST | +01:00
!  Fri Feb 26 14:45:00 2010 CLST | +10
!  Fri Feb 26 14:45:00 2010 CLST | +1000
!  Fri Feb 26 14:45:00 2010 CLST | +10:
!  Fri Feb 26 14:45:00 2010 CLST | +10:0
!  Fri Feb 26 14:45:00 2010 CLST | +10:00
!  Fri Feb 26 14:45:00 2010 CLST | +10:00:
!  Fri Feb 26 14:44:59 2010 CLST | +10:00:1
!  Fri Feb 26 14:44:59 2010 CLST | +10:00:01
!  Fri Feb 26 14:44:50 2010 CLST | +10:00:10
  (15 rows)
  
  -- these should fail
--- 1799,1821 ----
      ('+10:00:1'), ('+10:00:01'),
      ('+10:00:10'))
       SELECT make_timestamptz(2010, 2, 27, 3, 45, 00, tz), tz FROM tzs;
!        make_timestamptz       |    tz     
! ------------------------------+-----------
!  Fri Feb 26 23:45:00 2010 -03 | +1
!  Fri Feb 26 23:45:00 2010 -03 | +1:
!  Fri Feb 26 23:45:00 2010 -03 | +1:0
!  Fri Feb 26 23:45:00 2010 -03 | +100
!  Fri Feb 26 23:45:00 2010 -03 | +1:00
!  Fri Feb 26 23:45:00 2010 -03 | +01:00
!  Fri Feb 26 14:45:00 2010 -03 | +10
!  Fri Feb 26 14:45:00 2010 -03 | +1000
!  Fri Feb 26 14:45:00 2010 -03 | +10:
!  Fri Feb 26 14:45:00 2010 -03 | +10:0
!  Fri Feb 26 14:45:00 2010 -03 | +10:00
!  Fri Feb 26 14:45:00 2010 -03 | +10:00:
!  Fri Feb 26 14:44:59 2010 -03 | +10:00:1
!  Fri Feb 26 14:44:59 2010 -03 | +10:00:01
!  Fri Feb 26 14:44:50 2010 -03 | +10:00:10
  (15 rows)
  
  -- these should fail
***************
*** 1862,1882 ****
  ERROR:  time zone "Nehwon/Lankhmar" not recognized
  -- abbreviations
  SELECT make_timestamptz(2008, 12, 10, 10, 10, 10, 'CLST');
!        make_timestamptz        
! -------------------------------
!  Wed Dec 10 10:10:10 2008 CLST
  (1 row)
  
  SELECT make_timestamptz(2008, 12, 10, 10, 10, 10, 'CLT');
!        make_timestamptz        
! -------------------------------
!  Wed Dec 10 11:10:10 2008 CLST
  (1 row)
  
  SELECT make_timestamptz(2014, 12, 10, 10, 10, 10, 'PST8PDT');
!        make_timestamptz        
! -------------------------------
!  Wed Dec 10 15:10:10 2014 CLST
  (1 row)
  
  RESET TimeZone;
--- 1862,1882 ----
  ERROR:  time zone "Nehwon/Lankhmar" not recognized
  -- abbreviations
  SELECT make_timestamptz(2008, 12, 10, 10, 10, 10, 'CLST');
!        make_timestamptz       
! ------------------------------
!  Wed Dec 10 10:10:10 2008 -03
  (1 row)
  
  SELECT make_timestamptz(2008, 12, 10, 10, 10, 10, 'CLT');
!        make_timestamptz       
! ------------------------------
!  Wed Dec 10 10:10:10 2008 -03
  (1 row)
  
  SELECT make_timestamptz(2014, 12, 10, 10, 10, 10, 'PST8PDT');
!        make_timestamptz       
! ------------------------------
!  Wed Dec 10 15:10:10 2014 -03
  (1 row)
  
  RESET TimeZone;
***************
*** 2395,2437 ****
  SELECT '2007-12-09 06:00:00 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:00:00 2007 VET
  (1 row)
  
  SELECT '2007-12-09 06:30:00 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:30:00 2007 VET
  (1 row)
  
  SELECT '2007-12-09 06:59:59 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:59:59 2007 VET
  (1 row)
  
  SELECT '2007-12-09 07:00:00 UTC'::timestamptz;
!          timestamptz          
! ------------------------------
!  Sun Dec 09 02:30:00 2007 VET
  (1 row)
  
  SELECT '2007-12-09 07:00:01 UTC'::timestamptz;
!          timestamptz          
! ------------------------------
!  Sun Dec 09 02:30:01 2007 VET
  (1 row)
  
  SELECT '2007-12-09 07:29:59 UTC'::timestamptz;
!          timestamptz          
! ------------------------------
!  Sun Dec 09 02:59:59 2007 VET
  (1 row)
  
  SELECT '2007-12-09 07:30:00 UTC'::timestamptz;
!          timestamptz          
! ------------------------------
!  Sun Dec 09 03:00:00 2007 VET
  (1 row)
  
  RESET TimeZone;
--- 2395,2437 ----
  SELECT '2007-12-09 06:00:00 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:00:00 2007 -04
  (1 row)
  
  SELECT '2007-12-09 06:30:00 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:30:00 2007 -04
  (1 row)
  
  SELECT '2007-12-09 06:59:59 UTC'::timestamptz;
           timestamptz          
  ------------------------------
!  Sun Dec 09 02:59:59 2007 -04
  (1 row)
  
  SELECT '2007-12-09 07:00:00 UTC'::timestamptz;
!           timestamptz           
! --------------------------------
!  Sun Dec 09 02:30:00 2007 -0430
  (1 row)
  
  SELECT '2007-12-09 07:00:01 UTC'::timestamptz;
!           timestamptz           
! --------------------------------
!  Sun Dec 09 02:30:01 2007 -0430
  (1 row)
  
  SELECT '2007-12-09 07:29:59 UTC'::timestamptz;
!           timestamptz           
! --------------------------------
!  Sun Dec 09 02:59:59 2007 -0430
  (1 row)
  
  SELECT '2007-12-09 07:30:00 UTC'::timestamptz;
!           timestamptz           
! --------------------------------
!  Sun Dec 09 03:00:00 2007 -0430
  (1 row)
  
  RESET TimeZone;
***************
*** 2570,2582 ****
  SELECT '2007-12-09 06:30:00 UTC'::timestamptz AT TIME ZONE 'VET';
           timezone         
  --------------------------
!  Sun Dec 09 02:30:00 2007
  (1 row)
  
  SELECT '2007-12-09 06:59:59 UTC'::timestamptz AT TIME ZONE 'VET';
           timezone         
  --------------------------
!  Sun Dec 09 02:59:59 2007
  (1 row)
  
  SELECT '2007-12-09 07:00:00 UTC'::timestamptz AT TIME ZONE 'VET';
--- 2570,2582 ----
  SELECT '2007-12-09 06:30:00 UTC'::timestamptz AT TIME ZONE 'VET';
           timezone         
  --------------------------
!  Sun Dec 09 02:00:00 2007
  (1 row)
  
  SELECT '2007-12-09 06:59:59 UTC'::timestamptz AT TIME ZONE 'VET';
           timezone         
  --------------------------
!  Sun Dec 09 02:29:59 2007
  (1 row)
  
  SELECT '2007-12-09 07:00:00 UTC'::timestamptz AT TIME ZONE 'VET';

======================================================================