Submitted by: Alexander Tyutik (tut)

Duplicates CORE1227
Duplicates CORE1253
Is related to QA147

I found 2 probblems with new function LIST:

1) Function add unnecessary spaces at the end of each word when DISTINCT keyword used. Compare next 2 queries:

SELECT LIST(TEXT)
FROM (
SELECT 'bla-bla-bla' FROM RDB$DATABASE
UNION ALL
SELECT 'kuku' FROM RDB$DATABASE
UNION ALL
SELECT 'bla-bla-bla' FROM RDB$DATABASE
) (TEXT)

SELECT LIST(DISTINCT TEXT)
FROM (
SELECT 'bla-bla-bla' FROM RDB$DATABASE
UNION ALL
SELECT 'kuku' FROM RDB$DATABASE
UNION ALL
SELECT 'bla-bla-bla' FROM RDB$DATABASE
) (TEXT)

2) block size exceeds implementation restriction:

SELECT LIST(TEXT), LIST(DISTINCT TEXT)
FROM (
SELECT 'bla-bla-bla' FROM RDB$DATABASE
UNION ALL
SELECT 'kuku' FROM RDB$DATABASE
UNION ALL
SELECT 'bla-bla-bla' FROM RDB$DATABASE
) (TEXT)