[packages/postgresql.git] / postgresql-disable_horology_test.patch

#
# an ugly hack to disable some "horology" tests,which fail if built
# --with-system-tzdata and non-US /usr/share/zoneinfo/posixrules:
# http://www.nabble.com/Beta2-%22horology%22-test-failure-on-non-US-zoneinfo-posixrules-td13691442.html
#
--- postgresql-8.3RC1/src/test/regress/expected/horology.out	2007-07-25 18:22:36.000000000 +0100
+++ postgresql-8.3.0/src/test/regress/expected/horology.out	2008-02-04 20:20:16.091518646 +0000
@@ -602,30 +602,12 @@
 
 -- timestamp with time zone, interval arithmetic around DST change
 SET TIME ZONE 'CST7CDT';
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
-         Apr 3, 12:00         
-------------------------------
- Sun Apr 03 12:00:00 2005 CDT
-(1 row)
-
 SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
          Apr 3, 13:00         
 ------------------------------
  Sun Apr 03 13:00:00 2005 CDT
 (1 row)
 
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
-         Apr 2, 12:00         
-------------------------------
- Sat Apr 02 12:00:00 2005 CST
-(1 row)
-
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
-         Apr 2, 11:00         
-------------------------------
- Sat Apr 02 11:00:00 2005 CST
-(1 row)
-
 RESET TIME ZONE;
 SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am";
        Jan_01_1994_10am       
--- postgresql-8.3RC1/src/test/regress/sql/horology.sql	2007-07-25 18:22:37.000000000 +0100
+++ postgresql-8.3.0/src/test/regress/sql/horology.sql	2008-02-04 20:20:18.091381199 +0000
@@ -114,10 +114,7 @@
 
 -- timestamp with time zone, interval arithmetic around DST change
 SET TIME ZONE 'CST7CDT';
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
 SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
 RESET TIME ZONE;
Commit	Line	Data
23f835d4	1	#
	2	# an ugly hack to disable some "horology" tests,which fail if built
	3	# --with-system-tzdata and non-US /usr/share/zoneinfo/posixrules:
	4	# http://www.nabble.com/Beta2-%22horology%22-test-failure-on-non-US-zoneinfo-posixrules-td13691442.html
	5	#
	6	--- postgresql-8.3RC1/src/test/regress/expected/horology.out 2007-07-25 18:22:36.000000000 +0100
	7	+++ postgresql-8.3.0/src/test/regress/expected/horology.out 2008-02-04 20:20:16.091518646 +0000
	8	@@ -602,30 +602,12 @@
	9
	10	-- timestamp with time zone, interval arithmetic around DST change
	11	SET TIME ZONE 'CST7CDT';
	12	-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
	13	- Apr 3, 12:00
	14	-------------------------------
	15	- Sun Apr 03 12:00:00 2005 CDT
	16	-(1 row)
	17	-
	18	SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
	19	Apr 3, 13:00
	20	------------------------------
	21	Sun Apr 03 13:00:00 2005 CDT
	22	(1 row)
	23
	24	-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
	25	- Apr 2, 12:00
	26	-------------------------------
	27	- Sat Apr 02 12:00:00 2005 CST
	28	-(1 row)
	29	-
	30	-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
	31	- Apr 2, 11:00
	32	-------------------------------
	33	- Sat Apr 02 11:00:00 2005 CST
	34	-(1 row)
	35	-
	36	RESET TIME ZONE;
	37	SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am";
	38	Jan_01_1994_10am
	39	--- postgresql-8.3RC1/src/test/regress/sql/horology.sql 2007-07-25 18:22:37.000000000 +0100
	40	+++ postgresql-8.3.0/src/test/regress/sql/horology.sql 2008-02-04 20:20:18.091381199 +0000
	41	@@ -114,10 +114,7 @@
	42
	43	-- timestamp with time zone, interval arithmetic around DST change
	44	SET TIME ZONE 'CST7CDT';
	45	-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
	46	SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
	47	-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
	48	-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
	49	RESET TIME ZONE;
	50
	51