[pgsql-jp: 34231] postgres7.4.6 horology test FAILED

[Shigeo Yoshida]

こんにちは、吉田といいます。

VineLinux 2.6r4の環境にて現在postgresql7.4.5を使用しています。

今回、7.4.6にアップグレードしようとソースをダウンロードし、make checkしたところ
horology testにてFAILEDしました。
それ以外は全てPASSしています。

configureのオプションは特に指定していません。

$./configure
$make
$make check

という操作です。

現在運用中の7.4.5では、psqlよりregression.diffsにある２つの文を実行すると、いずれもtとなりました。

確認すべき点としてどのようなものがあるか、アドバイスいただけないでしょうか？


以下、regression.diffsおよびregression.out
===File ~/tmp/postgresql-7.4.6/src/test/regress/regression.diffs===
*** ./expected/horology.out	Thu Sep 25 15:58:06 2003
--- ./results/horology.out	Tue Nov  2 14:44:56 2004
***************
*** 577,583 ****
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
   True 
  ------
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
--- 577,583 ----
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
   True 
  ------
!  f
  (1 row)
  
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
***************
*** 589,595 ****
  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
   True 
  ------
!  t
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 589,595 ----
  SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
   True 
  ------
!  f
  (1 row)
  
  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";

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




===File ~/tmp/postgresql-7.4.6/src/test/regress/regression.out===
parallel group (13 tests):  char name varchar text int2 int4 oid boolean int8 float4 float8 bit numeric
     boolean              ... ok
     char                 ... ok
     name                 ... ok
     varchar              ... ok
     text                 ... ok
     int2                 ... ok
     int4                 ... ok
     int8                 ... ok
     oid                  ... ok
     float4               ... ok
     float8               ... ok
     bit                  ... ok
     numeric              ... ok
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  lseg box time path polygon circle point interval timetz comments abstime reltime tinterval date inet timestamp timestamptz type_sanity oidjoins opr_sanity
     point                ... ok
     lseg                 ... ok
     box                  ... ok
     path                 ... ok
     polygon              ... ok
     circle               ... ok
     date                 ... ok
     time                 ... ok
     timetz               ... ok
     timestamp            ... ok
     timestamptz          ... ok
     interval             ... ok
     abstime              ... ok
     reltime              ... ok
     tinterval            ... ok
     inet                 ... ok
     comments             ... ok
     oidjoins             ... ok
     type_sanity          ... ok
     opr_sanity           ... ok
test geometry             ... ok
test horology             ... FAILED
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator triggers vacuum constraints inherit create_misc
     constraints          ... ok
     triggers             ... ok
     create_misc          ... ok
     create_aggregate     ... ok
     create_operator      ... ok
     inherit              ... ok
     vacuum               ... ok
parallel group (2 tests):  create_view create_index
     create_index         ... ok
     create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (17 tests):  select_into select_distinct_on select_distinct select_having select_implicit random case union aggregates subselect update transactions portals hash_index arrays btree_index join
     select_into          ... ok
     select_distinct      ... ok
     select_distinct_on   ... ok
     select_implicit      ... ok
     select_having        ... ok
     subselect            ... ok
     union                ... ok
     case                 ... ok
     join                 ... ok
     aggregates           ... ok
     transactions         ... ok
     random               ... ok
     portals              ... ok
     arrays               ... ok
     btree_index          ... ok
     hash_index           ... ok
     update               ... ok
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 cluster select_views rules foreign_key
     select_views         ... ok
     portals_p2           ... ok
     rules                ... ok
     foreign_key          ... ok
     cluster              ... ok
parallel group (13 tests):  limit temp copy2 sequence truncate prepare polymorphism domain rangefuncs conversion without_oid plpgsql alter_table
     limit                ... ok
     plpgsql              ... ok
     copy2                ... ok
     temp                 ... ok
     domain               ... ok
     rangefuncs           ... ok
     prepare              ... ok
     without_oid          ... ok
     conversion           ... ok
     truncate             ... ok
     alter_table          ... ok
     sequence             ... ok
     polymorphism         ... ok
test stats                ... ok
============================================================