After updating from JOOQ 3.13.6 to 3.14.4 the generated SQL for functions
are now different and wrongly (""" instead of ") quoted for the
RenderQuotedNames.ALWAYS setting.
*3.13.6*
Executing query :
SELECT "insert_build"("incoming_build" := ROW(CAST(? AS timestamp with time
zone), ?, ?::"build_tool_type", ?, ?, ?))
*3.14.4*
Executing query :
SELECT """insert_build"""("incoming_build" := ROW(CAST(? AS timestamp with
time zone), ?, ?::"build_tool_type", ?, ?, ?))
Changing the setting to RenderQuotedNames.EXPLICIT_DEFAULT_QUOTED solves
the problem for us.
Has the semantic of RenderQuotedNames.ALWAYS changed since 3.14.x and is it
safe to use RenderQuotedNames.EXPLICIT_DEFAULT_QUOTED instead - we use some
explicit unquotedName() in our codebase.
Thanks
Johannes
BTW
I think the doc is wrong for the // Defaults to
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/73f6b491-4123-422d-8758-640cafcb5fdan%40googlegroups.com.
