SQLite group_concat(distinct...)

[Kevin Jones]

Hi Lukas,

I have a JOOQ query on SQLIte which looks like this:

    select(
                PLAYERSTEAMS.PLAYERID,
                TEAMSMATCHTYPES.MATCHTYPE,
                groupConcatDistinct(TEAMS.NAME).`as`("Teams")
            ).from(PLAYERSTEAMS)
....


The SQL this generates is:

select PlayersTeams.PlayerId,
                                TeamsMatchTypes.MatchType,
                                group_concat(distinct Teams.Name, ',') as
Teams
                         from PlayersTeams
....

But this doesn't run against SQLite (at least on my version which
is 3.45.3.0.

I *think* the SQL should be

select PlayersTeams.PlayerId,
                                TeamsMatchTypes.MatchType,
                                group_concat(distinct Teams.Name) as Teams
                         from PlayersTeams

as group_concat distinct in SQLIte can only use the default separator (I
think).

This is the Kotlin DSL, Jooq version 3.19.7

-- 
Kevin Jones
KnowledgeSpike

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/CAKT%3DYsPy71JgLPPMnY%3DhroEmy-cXT0Er%2BuaJ4QrmVRBak05PiQ%40mail.gmail.com.