pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Stabilize jsonb_path_query test case.
2+ messages / 1 participants
[nested] [flat]

* pgsql: Stabilize jsonb_path_query test case.
@ 2024-10-30 15:42  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2024-10-30 15:42 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Stabilize jsonb_path_query test case.

An operation like '12:34:56'::time_tz takes the UTC offset from
the prevailing time zone, which means that the results change
across DST transitions.  One of the test cases added in ed055d249
failed to consider this.

Per report from Bernhard Wiedemann.  Back-patch to v17, as the
test case was.

Discussion: https://postgr.es/m/ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/af21152268317323480caa790c4a6347110f8085

Modified Files
--------------
src/test/regress/expected/jsonb_jsonpath.out | 6 +++++-
src/test/regress/sql/jsonb_jsonpath.sql      | 4 ++++
2 files changed, 9 insertions(+), 1 deletion(-)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* pgsql: Stabilize jsonb_path_query test case.
@ 2024-10-30 15:42  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2024-10-30 15:42 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Stabilize jsonb_path_query test case.

An operation like '12:34:56'::time_tz takes the UTC offset from
the prevailing time zone, which means that the results change
across DST transitions.  One of the test cases added in ed055d249
failed to consider this.

Per report from Bernhard Wiedemann.  Back-patch to v17, as the
test case was.

Discussion: https://postgr.es/m/ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a358019159de68d4f045cbb5d89c8c8c2e96e483

Modified Files
--------------
src/test/regress/expected/jsonb_jsonpath.out | 6 +++++-
src/test/regress/sql/jsonb_jsonpath.sql      | 4 ++++
2 files changed, 9 insertions(+), 1 deletion(-)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-10-30 15:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-30 15:42 pgsql: Stabilize jsonb_path_query test case. Tom Lane <tgl@sss.pgh.pa.us>
2024-10-30 15:42 pgsql: Stabilize jsonb_path_query test case. 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