Subject distinct on list() function
Author Michal Kurczabinski
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