aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2017-02-19 16:14:52 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2017-02-19 16:14:52 -0500
commita8aeb871d9149e55839ffd0b4c62d24da5760f57 (patch)
treeecc4d06ec7ffe38681be5f4f4d057a08d71ca696
parenta83e7405a169d3b9ddef08e273ed1b1769fe3491 (diff)
downloadpostgresql-a8aeb871d9149e55839ffd0b4c62d24da5760f57.tar.gz
postgresql-a8aeb871d9149e55839ffd0b4c62d24da5760f57.zip
Adjust PL/Tcl regression test to dodge a possible bug or zone dependency.
One case in the PL/Tcl tests is observed to fail on RHEL5 with a Turkish time zone setting. It's not clear if this is an old Tcl bug or something odd about the zone data, but in any case that test is meant to see if the Tcl [clock] command works at all, not what its corner-case behaviors are. Therefore we have no need to test exactly which week a Sunday midnight is considered to fall into. Probe the following Tuesday instead. Discussion: https://postgr.es/m/797.1487517822@sss.pgh.pa.us
-rw-r--r--src/pl/tcl/expected/pltcl_setup.out2
-rw-r--r--src/pl/tcl/sql/pltcl_setup.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/pl/tcl/expected/pltcl_setup.out b/src/pl/tcl/expected/pltcl_setup.out
index 4183c14b28a..49b0893c707 100644
--- a/src/pl/tcl/expected/pltcl_setup.out
+++ b/src/pl/tcl/expected/pltcl_setup.out
@@ -507,7 +507,7 @@ CREATE OPERATOR CLASS tcl_int4_ops
create function tcl_date_week(int4,int4,int4) returns text as $$
return [clock format [clock scan "$2/$3/$1"] -format "%U"]
$$ language pltcl immutable;
-select tcl_date_week(2010,1,24);
+select tcl_date_week(2010,1,26);
tcl_date_week
---------------
04
diff --git a/src/pl/tcl/sql/pltcl_setup.sql b/src/pl/tcl/sql/pltcl_setup.sql
index 84629963229..44d69b5e24e 100644
--- a/src/pl/tcl/sql/pltcl_setup.sql
+++ b/src/pl/tcl/sql/pltcl_setup.sql
@@ -557,7 +557,7 @@ create function tcl_date_week(int4,int4,int4) returns text as $$
return [clock format [clock scan "$2/$3/$1"] -format "%U"]
$$ language pltcl immutable;
-select tcl_date_week(2010,1,24);
+select tcl_date_week(2010,1,26);
select tcl_date_week(2001,10,24);
-- test pltcl event triggers