Re: [sqlite] group_concat and empty strings

sqlite> .null NULL sqlite> select group_concat(''); NULL sqlite> select group_concat(x''); NULL sqlite> I would think it is a bug. At the very least, it is not consistent with the description of the function. It seams to happen only when the only thing being concatenated is a zero length string

[sqlite] group_concat and empty strings

On http://www.sqlite.org/cvstrac/tktview?tn=3806 this bug is fixed. But I still get a NULL with group_concat(distinct x) with the latest windows sqlite shell: SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .null NULL s