Context parsing error with derived tables and CASE functions
------------------------------------------------------------
Key: CORE-4262
URL: http://tracker.firebirdsql.org/browse/CORE-4262
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: Dmitry Yemanov
Purely artificial test case that's not expected to demonstrate anything useful,
just to either compile or not:
SELECT
CASE WHEN col = 'low' THEN -1
WHEN col = 'high' THEN 1
END as text
FROM (
SELECT CASE WHEN EXISTS (SELECT 1 FROM rdb$database WHERE rdb$relation_id =
r.rdb$relation_id - 1) THEN 'low'
WHEN EXISTS (SELECT 1 FROM rdb$database WHERE rdb$relation_id =
r.rdb$relation_id + 1) THEN 'high'
END as col
FROM rdb$relations as r
)
Statement failed, SQLSTATE = HY000
invalid request BLR at offset 171
-context already in use (BLR error)
In FB 2.5 there's not such a context parsing problem.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
