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 or blob.
--David Garfield
Jan writes:
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
