Re: [firebird-support] distinct on list() function

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 12-11-2019 13:37, Michal Kurczabinski michk...@gmail.com 
[firebird-support] wrote:
> Is this old bug from FB 2.5.x  or some kind of feature ?
> 
> This still exists in FB 3.x

It would be helpful to also describe the problem, and not only let 
people execute a query and try to guess what problem you're seeing.

Mark
-- 
Mark Rotteveel

[firebird-support] distinct on list() function

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

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