Skip site navigation (1) Skip section navigation (2)

pgsql: Fix an old problem in decompilation of CASE constructs: the

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix an old problem in decompilation of CASE constructs: the
Date: 2009-02-25 18:00:01
Message-ID: 20090225180001.E4D077559ED@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix an old problem in decompilation of CASE constructs: the ruleutils.c code
looks for a CaseTestExpr to figure out what the parser did, but it failed to
consider the possibility that an implicit coercion might be inserted above
the CaseTestExpr.  This could result in an Assert failure in some cases
(but correct results if Asserts weren't enabled), or an "unexpected CASE WHEN
clause" error in other cases.  Per report from Alan Li.

Back-patch to 8.1; problem doesn't exist before that because CASE was
implemented differently.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        ruleutils.c (r1.295 -> r1.296)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.295&r2=1.296)

pgsql-committers by date

Next:From: Tom LaneDate: 2009-02-25 18:00:07
Subject: pgsql: Fix an old problem in decompilation of CASE constructs: the
Previous:From: Magnus HaganderDate: 2009-02-25 17:42:19
Subject: pgsql: Remove references to foreign data wrapper libraries, since they

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group