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 sqlite> create table tbl (a int, b text); sqlite> insert into tbl values(1, ''); sqlite> insert into tbl values(1, ''); sqlite> select a, group_concat(b) from tbl group by a; 1|, sqlite> select a, group_concat(distinct b) from tbl group by a; 1|NULL Is this behaviour correct? Thank you, Jan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
