A modern programming language that makes developers happier.

kotlinlang

i’m having trouble with a query that contains ‘group_concat’. The column may be null, yet the generated field is non-null

I guess it was assumed that `group_concat` would return non-null. Which I also thought was the case.

After some looking up, the result should be non-null. <https://www.sqlite.org/lang_aggfunc.html#groupconcat>
As it skips the null values.

yes, it only gets the non-null. but the result of a concat, in a left join may be null

idk if it supposed to, or its a bug in the generated code