Skip to content
Advertisement

jOOQ surrounds functions with quotes even if the setting is turned off

I’ve turned off adding quotes in the settings:

But when I check the SQL log I still find double quotes in the output. jOOQ adds it to function calls:

And procedure calls:

Is this a bug? Or do I have to configure something else?

Advertisement

Answer

A related bug has been reported recently. Perhaps a 3.12 regression: https://github.com/jOOQ/jOOQ/issues/9813. We’re currently investigating this.

A workaround would be to implement an ExecuteListener and regex-replace all function identifiers ."(w+)"( by .$1(:

Of course, that’s a workaround and it could match things by accident that it shouldn’t…

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement