From: | "Peter Speck" <speck(at)vitality(dot)dk> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5794: 'explain' fails, but executing sql is ok. |
Date: | 2010-12-19 17:27:47 |
Message-ID: | 201012191727.oBJHRlkg009881@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5794
Logged by: Peter Speck
Email address: speck(at)vitality(dot)dk
PostgreSQL version: 9.0.2
Operating system: Mac OS X Server 10.6.5
Description: 'explain' fails, but executing sql is ok.
Details:
The following SQL succeeds when executed as-is, but when the SELECT is
prepended with 'EXPLAIN', it fails with:
ERROR: XX000: unexpected CASE WHEN clause: 314
LOCATION: get_rule_expr, ruleutils.c:4939
CREATE TABLE z (tag VARCHAR(30)); -- empty
SELECT t.*
FROM (
SELECT
CASE tag
WHEN 'a' THEN 'a'
ELSE
CASE TRUE
WHEN (tag LIKE 'abc%' OR tag LIKE 'def%' ) THEN 'b'
ELSE 'c'
END
END AS stuff
FROM z
) AS t
ORDER BY CASE TRUE WHEN t.stuff LIKE 'ghi%' THEN t.stuff ELSE 'z' END;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-12-19 20:34:47 | Re: BUG #5794: 'explain' fails, but executing sql is ok. |
Previous Message | Magnus Hagander | 2010-12-19 13:21:42 | Re: [Fwd: DBD::Pg on HP-UX 11.31 64bit] |