Re: Regression error on unixware 7 and open unix 8

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: ohp(at)pyrenet(dot)fr, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Regression error on unixware 7 and open unix 8
Date: 2001-10-30 01:01:19
Message-ID: 20011030100119A.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Olivier PRENANT <ohp(at)pyrenet(dot)fr> writes:
> > While testing 7.2b1 on unixware 711 and open unix 8 I have those errors on
> > abstime, tinterval and horology.
>
> Not surprising, since the solaris variant files have not been updated
> for the recent changes in these regression tests. Would you send me
> your actual results files for these tests, and I'll commit them as the
> new expected files?

I got timetz and horology errors on my Linux box (a variant of RH6.2)
with 7.2b1. (Actually I got geometry error too, but it seems just a
precision difference). They seem not trivial. Any idea?

*** ./expected/timetz.out Wed Oct 3 14:29:26 2001
--- ./results/timetz.out Mon Oct 29 15:42:27 2001
***************
*** 33,51 ****
00:01:00-07
01:00:00-07
02:03:00-07
! (3 rows)

SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
Seven
----------------
07:07:00-08
- 08:08:00-04
11:59:00-07
12:00:00-07
12:01:00-07
23:59:00-07
23:59:59.99-07
! (7 rows)

SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
None
--- 33,51 ----
00:01:00-07
01:00:00-07
02:03:00-07
! 08:08:00-04
! (4 rows)

SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';
Seven
----------------
07:07:00-08
11:59:00-07
12:00:00-07
12:01:00-07
23:59:00-07
23:59:59.99-07
! (6 rows)

SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';
None

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

*** ./expected/horology.out Sat Oct 20 10:02:21 2001
--- ./results/horology.out Mon Oct 29 15:42:31 2001
***************
*** 295,307 ****
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";
--- 295,307 ----
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";
***************
*** 548,554 ****
+ 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-08'
--- 548,554 ----
+ 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-08'

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2001-10-30 01:01:56 pgsql-committers?
Previous Message Tom Lane 2001-10-30 00:56:32 Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...