Submitted by: Nick Dirov (dnn)

select distinct f1, list(f2)
from
(select f1, f2
from
(select 1 as f1, 'a' as f2 from rdb$database
union
select 2 as f1, 'b' as f2 from rdb$database
union
select 2 as f1, 'c' as f2 from rdb$database
union
select 3 as f1, 'e' as f2 from rdb$database)
order by 1, 2 desc)
group by 1

return
1- a
2- b,c
3- e

instead of expected
1- a
2- c,b
^^^^
3- e

so as we watch order by clause ignored when group by distinct ..

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

No sense in test because LIST function does not guarantee any particular order.