pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / 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