Subject Re: [firebird-support] SELECT with CTE and LIST: Duplicates with DISTINCT and incorrect ordering in the main select
Author Michal Kurczabinski
Post date 2017-05-30T09:15:43Z
In future beware of something like this:

select cast('text' as blob)a from rdb$database
union
select cast('text' as blob)a from rdb$database


list() returns blob...

http://tracker.firebirdsql.org/browse/CORE-1345



--
regards,
Michał Kurczabiński