https://kotlinlang.org logo
#squarelibraries
Title
# squarelibraries
m

myanmarking

12/16/2020, 12:15 AM
i’m having trouble with a query that contains ‘group_concat’. The column may be null, yet the generated field is non-null
d

Dominaezzz

12/16/2020, 12:25 AM
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.
m

myanmarking

12/16/2020, 12:42 AM
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