[Bernhard M. Wiedemann <bwiedemann@suse.de>]

While working on reproducible builds for openSUSE, I found that
our postgresql17 package fails the jsonb_jsonpath test
when building after 2024-11-03 (the US DST change).

Background:
As part of my work on reproducible builds for openSUSE, I check that 
software still gives identical build results in the future.
The usual offset is +16.1 years, because that is how long I expect some 
software will be used in some places.
This showed up failing tests in our package build.
See https://reproducible-builds.org/ for why this matters.

Here is the test log:

  # 1 of 221 tests failed.
  # The differences that caused some tests to fail can be viewed in the 
file 
"/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/regression.diffs".
  # A copy of the test summary that you see above is saved in the file 
"/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/regression.out".
[...snipped...]
  diff -U3 
/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/expected/jsonb_jsonpath.out 
/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/results/jsonb_jsonpath.out
  --- 
/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/expected/jsonb_jsonpath.out 
   2024-09-23 20:02:53.000000000 +0000
  +++ 
/home/abuild/rpmbuild/BUILD/postgresql-17.0/src/test/regress/results/jsonb_jsonpath.out 
    2040-11-25 10:30:31.159999999 +0000
  @@ -2637,7 +2637,7 @@
   select jsonb_path_query_tz('"12:34:56"', '$.time_tz().string()');
    jsonb_path_query_tz
   ---------------------
  - "12:34:56-07:00"
  + "12:34:56-08:00"
   (1 row)

   select jsonb_path_query('"12:34:56"', '$.time().string()');
  + exit 1


On Debian or openSUSE you can test it with
osc checkout openSUSE:Factory/postgresql17 && cd $_
osc build --vm-type=kvm --noservice --clean \
--build-opt=--vm-custom-opt="-rtc base=2024-11-04T00:00:00" standard

Tests should be designed to continue working into the far future.

Ciao
Bernhard M.


Attachments:

  OpenPGP_signature.asc (application/pgp-signature, 235B) download