Skip to content
Advertisement

Jooq Java CTE wrong render

I have CTE that is been creating from DSL.values:

JavaScript

Then i am trying use it to get needed values from DB

JavaScript

But i have only the next error

JavaScript

I suppose it happens because of (select * from (values(cast(? as varchar))

How to fix it? Other methods without cte work fine.

Advertisement

Answer

The problem was there:

JavaScript

“Id” is needed to be wraped by DSL.name()

JavaScript
Advertisement