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...