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)
commitaf21152268317323480caa790c4a6347110f8085
tree3b5daccb3b23a1167181c68ecbcbac59e5b2a516
parent763d65ae254569e0bdbe2cbb27b184112765f24f
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