reporter: Dmitry Yemanov [ dimitr ] => Pavel Zotov [ tabloid ]

description: 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.

=>

Purely artificial test case that's not expected to demonstrate anything useful, just to either compile or not:

SELECT
CASE WHEN col = 1 THEN 'Y'
WHEN col = 0 THEN 'N'
END AS text
FROM (
SELECT CASE WHEN EXISTS (SELECT 1 FROM rdb$database ) THEN 1 ELSE 0 END AS col
FROM rdb$relations
)

Statement failed, SQLSTATE = HY000
invalid request BLR at offset 113
-context already in use (BLR error)

In FB 2.5 there's not such a context parsing problem.

description: Purely artificial test case that's not expected to demonstrate anything useful, just to either compile or not:

SELECT
CASE WHEN col = 1 THEN 'Y'
WHEN col = 0 THEN 'N'
END AS text
FROM (
SELECT CASE WHEN EXISTS (SELECT 1 FROM rdb$database ) THEN 1 ELSE 0 END AS col
FROM rdb$relations
)

Statement failed, SQLSTATE = HY000
invalid request BLR at offset 113
-context already in use (BLR error)

In FB 2.5 there's not such a context parsing problem.

=>

Purely artificial test case that's not expected to demonstrate anything useful, just to either compile or not:

SELECT
CASE WHEN col = 1 THEN 'Y'
WHEN col = 0 THEN 'N'
END AS text
FROM (
SELECT CASE WHEN EXISTS (SELECT 1 FROM rdb$database ) THEN 1 ELSE 0 END AS col
FROM rdb$relations
)

or

SELECT col AS col1, col AS col2
FROM (
SELECT CASE WHEN EXISTS (SELECT 1 FROM rdb$database ) THEN 1 ELSE 0 END AS col
FROM rdb$relations
)

Statement failed, SQLSTATE = HY000
invalid request BLR at offset <NNN>
-context already in use (BLR error)

In FB 2.5 there's not such a context parsing problem.

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

assignee: Dmitry Yemanov [ dimitr ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully