From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | PG17 failing tests (DST related?) |
Date: | 2024-11-11 15:29:51 |
Message-ID: | CA+OCxowXN-3S5G5K74oZw6sD-3kVwRhZjYMMLxZM7JNxG3AFZg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
For about a week, the Windows builds I've been running in Github have been
failing for PG17:
https://github.com/dpage/winpgbuild/actions/workflows/postgresql.yml. The
consistently failing tests are:
postgresql:recovery / recovery/027_stream_regress
postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade
postgresql:regress / regress/regress
which all appear to have the same failure in jsonb_jsonpath:
=====
diff --strip-trailing-cr -U3
D:/a/winpgbuild/winpgbuild/postgresql-17.0/src/test/regress/expected/jsonb_jsonpath.out
D:/a/winpgbuild/winpgbuild/postgresql-17.0/build/testrun/regress/regress/results/jsonb_jsonpath.out
---
D:/a/winpgbuild/winpgbuild/postgresql-17.0/src/test/regress/expected/jsonb_jsonpath.out
2024-09-23 20:02:53.000000000 +0000
+++
D:/a/winpgbuild/winpgbuild/postgresql-17.0/build/testrun/regress/regress/results/jsonb_jsonpath.out
2024-11-11 04:16:42.243042300 +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()');
=====
It seems likely this is related to the DST change in the US, as the issue
started occurring on 4th November.
--
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-11-11 15:35:04 | Re: PG17 failing tests (DST related?) |
Previous Message | Tomas Vondra | 2024-11-11 14:17:36 | Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 |