summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-05-26 19:25:19 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2011-05-26 19:26:04 -0400
commitf014211849e405b1784f0bfc9d4f6bd7d06f269f (patch)
treec8d6ef210deff08cdf7dc7942801bb919d1beb03 /doc/src
parent9a57eafe9d29280fa65c5912df38fc8650507035 (diff)
Make decompilation of optimized CASE constructs more robust.
We had some hacks in ruleutils.c to cope with various odd transformations that the optimizer could do on a CASE foo WHEN "CaseTestExpr = RHS" clause. However, the fundamental impossibility of covering all cases was exposed by Heikki, who pointed out that the "=" operator could get replaced by an inlined SQL function, which could contain nearly anything at all. So give up on the hacks and just print the expression as-is if we fail to recognize it as "CaseTestExpr = RHS". (We must cover that case so that decompiled rules print correctly; but we are not under any obligation to make EXPLAIN output be 100% valid SQL in all cases, and already could not do so in some other cases.) This approach requires that we have some printable representation of the CaseTestExpr node type; I used "CASE_TEST_EXPR". Back-patch to all supported branches, since the problem case fails in all.
Diffstat (limited to 'doc/src')
0 files changed, 0 insertions, 0 deletions