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

2019-11-12 Thread 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 proble

[firebird-support] distinct on list() function

2019-11-12 Thread 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