BUG #16689: timetz test fails 2020-11-01

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: githubbmw2020(at)lsmod(dot)de
Subject: BUG #16689: timetz test fails 2020-11-01
Date: 2020-10-29 17:54:03
Message-ID: 16689-57701daa23b377bf@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16689
Logged by: Bernhard M. Wiedemann
Email address: githubbmw2020(at)lsmod(dot)de
PostgreSQL version: 12.4
Operating system: openSUSE-Tumbleweed
Description:

timetz test fails after 2020-11-01
likely from upcoming daylight saving time changes in the US

diff -U3
/home/abuild/rpmbuild/BUILD/postgresql-12.4/src/test/regress/expected/timetz.out
/home/abuild/rpmbuild/BUILD/postgresql-12.4/src/test/regress/results/timetz.out
---
/home/abuild/rpmbuild/BUILD/postgresql-12.4/src/test/regress/expected/timetz.out
2020-08-10 21:15:53.000000000 +0000
+++
/home/abuild/rpmbuild/BUILD/postgresql-12.4/src/test/regress/results/timetz.out
2035-11-30 21:20:50.205175526 +0000
@@ -94,25 +94,25 @@
SELECT '23:59:59.999999'::timetz;
timetz
--------------------
- 23:59:59.999999-07
+ 23:59:59.999999-08
(1 row)

SELECT '23:59:59.9999999'::timetz; -- rounds up
timetz
-------------
- 24:00:00-07
+ 24:00:00-08
(1 row)

SELECT '23:59:60'::timetz; -- rounds up
timetz
-------------
- 24:00:00-07
+ 24:00:00-08
(1 row)

SELECT '24:00:00'::timetz; -- allowed
timetz
-------------
- 24:00:00-07
+ 24:00:00-08
(1 row)

SELECT '24:00:00.01'::timetz; -- not allowed
+ exit 1

To reproduce on Debian or openSUSE:
osc checkout openSUSE:Factory/postgresql12 && cd $_
osc build --vm-type=kvm --noservice --build-opt=--vm-custom-opt="-rtc
base=2020-11-01T08:00:00" standard

Background:
As part of my work on reproducible builds for openSUSE, I check that
software still gives identical build results in the future.
This showed up failing tests in our package build. Then I bisected the
failure date.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-10-29 19:10:23 Re: BUG #16689: timetz test fails 2020-11-01
Previous Message Tom Lane 2020-10-29 15:51:12 Re: Calling variadic function with default value in named notation