Re: Regression error on unixware 7 and open unix 8

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Regression error on unixware 7 and open unix 8
Дата
Msg-id 20011030100119A.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Regression error on unixware 7 and open unix 8  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Regression error on unixware 7 and open unix 8  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Olivier PRENANT <ohp@pyrenet.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'

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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: pgsql-committers?