| Ticket Hash: | 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:
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: I think you want: select group_concat(a, '#') from test; | ||||
