Jippe Holwerda

The MULTISET JSON emulation doesn't work with DISTINCT in PostgreSQL

7

After upgrading from 3.16 to 3.17.2 the following jOOQ code gives an error in Postgres 13: ```kotlin context.selectDistinct( ZKN_ZAAK.ID.convertFrom { ZaakId(it!!) }, multiset( permissieFields(context) .from(ZKN_AUTORISATIE) .join(STD_PERMISSIE).onKey() .where(ZKN_ROL.ROLTYPE_ALIAS_ID.eq(ZKN_AUTORISATIE.ROLTYPE_ID)) ).convertFrom { it.map(mapping(::Permissie))...

New release?

6

Hi! Would it be possible to release a new version? Anything I can do to help with that? Cheers!