Using MULTISET in mariadb with JOINS on tables that contain JSON column

[Bernd Huber]

Just a general question, without providing exact jooq version or bug report (i may do so when i know more about the problem).

when using jooq multiset query,

is it possible that when selecting JSON columns (datatype: JSON), via multiset, that the resulting String representation in Java (on the Jooq-Record) could be kind of scrambled.

Is this a known issue?

otherwise i can create a bug report.

It's not a big problem as we currently don't use the JSON datatype of mariadb. We use longtext instead, and the problem is only seen with datatype JSON.

best regards :)

[Lukas Eder]

Hi Bernd,

It should be possible to embed JSON content in MULTISET. Please provide more context and a reproducer in a complete bug report here:

https://github.com/jOOQ/jOOQ/issues/new/choose

Our template for reproducers supports MariaDB, so it should be simple to show what's not working for you:

https://github.com/jOOQ/jOOQ-mcve

Best Regards,

Lukas

--
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+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/jooq-user/25fd2485-913c-4420-afe7-dfe8353e87f6n%40googlegroups.com.

[Bernd Huber]

i have done so, worked great btw. See:

- https://github.com/jOOQ/jOOQ/issues/18113