System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 8421d26df1b9edd8f8f52839606ae0f0d0f3c471
Title: wrong result group_concat
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Native_Assembly Resolution: Works_As_Designed
Last Modified: 2018-02-27 14:13:22
Version Found In: 1.0.107.0
User Comments:
anonymous added on 2018-02-27 12:43:45: (text/x-fossil-plain)
create temp table test (a);
insert into test(a) values (1);
insert into test(a) values (2);
insert into test(a) values (3);
select group_concat(a)  from test; --> 1,2,3 
select group_concat('#', a)  from test; --> #2#3#

mistachkin added on 2018-02-27 14:13:09: (text/x-fossil-plain)
I think you want:

select group_concat(a, '#')  from test;