pgsql: Stabilize jsonb_path_query test case.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Stabilize jsonb_path_query test case.
Date: 2024-10-30 15:42:41
Message-ID: E1t6AqI-003AVx-FH@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2024-10-30 16:29:12 pgsql: Optimize sifting down in binaryheap.
Previous Message Tom Lane 2024-10-30 15:00:40 Re: pgsql: Update time zone data files to tzdata release 2024b.