Jooq version: 3.4.0
The following code:
Field column = DSL.fieldByName("Table","Column");
Field caseWhen = DSL.decode().when(column.isNull(), 0).otherwise(column);
Condition condition = caseWhen.lessOrEqual("Value");
System.out.println("Condition: " + condition);
outputs:
Condition: case when "Table"."Column" is null then 0 else "Column" end <=
null
expected:
Condition: case when "Table"."Column" is null then 0 else "Table"."Column"
end <= "Value"
If I wrap the value as a field it doesn't make the field null, but I would
like to be able to compare the results of the case statement with a string
literal. Any suggestions for a workaround?
--
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].
For more options, visit https://groups.google.com/d/optout.
