Submitted by: John Kilin (johnkilin)

Duplicates CORE2893

Test case is below. Expected results are: {0, 1}. Wrong results are: {0, 0}.

select (select case when R.RDB$Relation_ID = 0 then 0 else 1 end from RDB$Database) TypeID
from RDB$Relations R
where R.RDB$Relation_ID < 2
-- correct

select *
from (
select (select case when R.RDB$Relation_ID = 0 then 0 else 1 end from RDB$Database) TypeID
from RDB$Relations R
where R.RDB$Relation_ID < 2
)
-- wrong

select *
from (
select (case when R.RDB$Relation_ID = 0 then 0 else 1 end) TypeID
from RDB$Relations R
where R.RDB$Relation_ID < 2
)
-- correct

====== Test Details ======

See test for core-2893.