pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16689: timetz test fails 2020-11-01
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2020-10-29 4a071afbd0 ee03baad26 25b587f03a 24d769b905 c39f4e81dc Stabilize timetz test across DST transitions.
* BUG #16689: timetz test fails 2020-11-01
@ 2020-10-29 17:54 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-10-29 17:54 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: githubbmw2020@lsmod.de
The following bug has been logged on the website:
Bug reference: 16689
Logged by: Bernhard M. Wiedemann
Email address: githubbmw2020@lsmod.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16689: timetz test fails 2020-11-01
@ 2020-10-29 19:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-10-29 19:10 UTC (permalink / raw)
To: githubbmw2020@lsmod.de; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> timetz test fails after 2020-11-01
> likely from upcoming daylight saving time changes in the US
Hmm, those test cases were just added a couple months ago, so they
have not survived a DST transition yet. Thanks for the heads-up!
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-10-29 19:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-29 17:54 BUG #16689: timetz test fails 2020-11-01 PG Bug reporting form <noreply@postgresql.org>
2020-10-29 19:10 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox