Stabilize jsonb_path_query test case.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 30 Oct 2024 15:42:28 +0000 (11:42 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 30 Oct 2024 15:42:34 +0000 (11:42 -0400)
commita358019159de68d4f045cbb5d89c8c8c2e96e483
tree9788114bf408e254cb85f3a68939d4a5d5c8d7c1
parentc177726ae41a4c13c575f2adf8942687fb6ec954
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
src/test/regress/expected/jsonb_jsonpath.out
src/test/regress/sql/jsonb_jsonpath.sql