Is this old bug from FB 2.5.x or some kind of feature ? This still exists in FB 3.x
with cte as (select 1 cnt from rdb$database union all select 2 from rdb$database ) select list(cnt) from cte union select list(cnt) from cte -- Regards, Michał Kurczabiński