Re: Call for port reports / test horology FAILED - Mailing list pgsql-hackers

Hi together, keep on the nice work!

On SuSE 8.0,
> uname -a
Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown

During compile I got the following warning:
gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../src/include -D_GNU_SOURCE   -c trigger.c -o
trigger.o
/tmp/ccgcppC9.s: Assembler messages:
/tmp/ccgcppC9.s:2014: Warning: using `%si' instead of `%esi' due to `w' suffix
/tmp/ccgcppC9.s:2014: Warning: using `%ax' instead of `%eax' due to `w' suffix

> as -v
GNU assembler version 2.11.92.0.10 (i486-suse-linux) using BFD version
2.11.92.0.10 20011021 (SuSE)
> gcc -v
Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)

I get the this failure (...something to do with the change to winter time last
night?):

test horology             ... FAILED, diff follows.

Bye,
Tilo

> cat src/test/regress/regression.diffs
*** ./expected/horology.out     Thu Sep 25 08:58:06 2003
--- ./results/horology.out      Sun Oct 26 22:54:56 2003
***************
*** 583,595 **** SELECT (timestamp with time zone 'today' = (timestamp with time zone
'tomorrow' - interval '1 day')) as "True";  True ------
!  t (1 row)
 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";
--- 583,595 ---- SELECT (timestamp with time zone 'today' = (timestamp with time zone
'tomorrow' - interval '1 day')) as "True";  True ------
!  f (1 row)
 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";
***************
*** 836,842 ****             + interval '02:01' AS time with time zone) AS time) AS
"03:31:00";  03:31:00 ----------
!  03:31:00 (1 row)
 SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 836,842 ----             + interval '02:01' AS time with time zone) AS time) AS
"03:31:00";  03:31:00 ----------
!  02:31:00 (1 row)
 SELECT CAST(cast(date 'today' + time with time zone '03:30'

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

*** ./expected/random.out       Thu Feb 13 06:24:04 2003
--- ./results/random.out        Sun Oct 26 22:55:01 2003
***************
*** 25,31 ****   GROUP BY random HAVING count(random) > 1;  random | count --------+-------
! (0 rows)
 SELECT random FROM RANDOM_TBL   WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----   GROUP BY random HAVING count(random) > 1;  random | count --------+-------
!     113 |     2
! (1 row)
 SELECT random FROM RANDOM_TBL   WHERE random NOT BETWEEN 80 AND 120;

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