Thread: [COMMITTERS] pgsql: Disable transforms that replaced AT TIME ZONE with RelabelType.
[COMMITTERS] pgsql: Disable transforms that replaced AT TIME ZONE with RelabelType.
From
Tom Lane
Date:
Disable transforms that replaced AT TIME ZONE with RelabelType. These resulted in wrong answers if the relabeled argument could be matched to an index column, as shown in bug #14504 from Evgeniy Kozlov. We might be able to resurrect these optimizations by adjusting the planner's treatment of RelabelType, or by adjusting btree's rules for selecting comparison functions, but either solution will take careful analysis and does not sound like a fit candidate for backpatching. I left the catalog infrastructure in place and just reduced the transform functions to always-return-NULL. This would be necessary anyway in the back branches, and it doesn't seem important to be more invasive in HEAD. Bug introduced by commit b8a18ad48. Back-patch to 9.5 where that came in. Report: https://postgr.es/m/20170118144828.1432.52823@wrigleys.postgresql.org Discussion: https://postgr.es/m/18771.1484759439@sss.pgh.pa.us Branch ------ REL9_6_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/b21e665f2df7ba6611d2fa6f845e4803deaf14c3 Modified Files -------------- src/backend/utils/adt/timestamp.c | 123 +++--------------------------- src/test/regress/expected/timestamptz.out | 19 +++++ src/test/regress/sql/timestamptz.sql | 9 +++ 3 files changed, 38 insertions(+), 113 deletions(-)