| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> | 
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org | 
| Subject: | pgsql: Fix coerce_to_target_type for coerce_type's klugy handling of CO | 
| Date: | 2012-01-02 19:44:03 | 
| Message-ID: | E1Rhnnf-0003Do-Ob@gemulon.postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-committers | 
Fix coerce_to_target_type for coerce_type's klugy handling of COLLATE.
Because coerce_type recurses into the argument of a CollateExpr,
coerce_to_target_type's longstanding code for detecting whether coerce_type
had actually done anything (to wit, returned a different node than it
passed in) was broken in 9.1.  This resulted in unexpected failures in
hide_coercion_node; which was not the latter's fault, since it's critical
that we never call it on anything that wasn't inserted by coerce_type.
(Else we might decide to "hide" a user-written function call.)
Fix by removing and replacing the CollateExpr in coerce_to_target_type
itself.  This is all pretty ugly but I don't immediately see a way to make
it nicer.
Per report from Jean-Yves F. Barbier.
Branch
------
REL9_1_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/188f1b928205bf33ce29887eeeee26ce9227908f
Modified Files
--------------
src/backend/parser/parse_coerce.c     |   28 +++++++++++++++++++++++++++-
src/test/regress/expected/collate.out |    3 +++
src/test/regress/sql/collate.sql      |    5 +++++
3 files changed, 35 insertions(+), 1 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2012-01-02 20:12:43 | pgsql: pg_regress: Replace exit_nicely() with exit() plus atexit() hook | 
| Previous Message | Bruce Momjian | 2012-01-02 13:49:14 | pgsql: Add comment about skipping binary files for copyright changes. |