pgsql: Stabilize jsonb_path_query test case. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Stabilize jsonb_path_query test case.
Date
Msg-id E1t6AqI-003AVw-Eq@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Update time zone data files to tzdata release 2024b.
Next
From: Nathan Bossart
Date:
Subject: pgsql: Optimize sifting down in binaryheap.