Hinrichsen, John wrote:
> Are the results below expected?
> sqlite> SELECT (SELECT GROUP_CONCAT(DISTINCT COALESCE(a,'')) FROM z) IS NULL;
> 1
You don't need DISTINCT:
sqlite> select typeof(group_concat(''));
null
The documentation says:
| The group_concat() function returns a string which is the
| concatenation of all non-NULL values of X.
So this is a bug.
(AFAICS groupConcatStep() does not bother to do anything for empty
strings, so those are handled as if they had been NULL.)
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
