Обсуждение: Re: [PATCHES] Interval->day docs and regression tests

Поиск
Список
Период
Сортировка

Re: [PATCHES] Interval->day docs and regression tests

От
Tom Lane
Дата:
Michael Glaesemann <grzm@myrealbox.com> writes:
> Please find attached diffs for documentation and simple regression  
> tests for the new interval->day changes.

The buildfarm results suggest that justify_days is broken in the
integer-datetimes case, eg from panda:

*** ./expected/interval.out     Sat Jul 30 16:20:48 2005
--- ./results/interval.out      Sat Jul 30 16:24:31 2005
***************
*** 238,243 **** SELECT justify_days(interval '6 months 36 days 5 hours 4 minutes 3 seconds') as "7 mons 6 days 5 hours
4mins 3 seconds";  7 mons 6 days 5 hours 4 mins 3 seconds  ----------------------------------------
 
!  @ 7 mons 6 days 5 hours 4 mins 3 secs (1 row) 
--- 238,243 ---- SELECT justify_days(interval '6 months 36 days 5 hours 4 minutes 3 seconds') as "7 mons 6 days 5 hours
4mins 3 seconds";  7 mons 6 days 5 hours 4 mins 3 seconds  ----------------------------------------
 
!  @ 1 mon 186 days 5 hours 4 mins 3 secs (1 row) 
        regards, tom lane