Subject Re: [firebird-support] SELECT with CTE and LIST: Duplicates with DISTINCT and incorrect ordering in the main select
Author Michal Kurczabinski
First thought:
you should cast as varchar list expr as
cast (list(distinct 'I shouldn''t duplicate') as varchar(100)), cast(list(distinct substring('Hello' from 1 for 5)) as varchar(100))
in each occurence of list

Michał Kurczabiński