Support case clauses requiring casts with DB2

Description

This is a follow-up of https://hibernate.atlassian.net/browse/HHH-12822.

Apparently, in certain conditions, DB2 requires casts in when and else clauses of a case.

Note that we already have:

so I suspect something similar is required.

Environment

None

Activity

Show:
Mark Rotteveel
June 15, 2019, 1:08 PM

Firebird has similar needs. Although in recent versions of Firebird this has been improved, it doesn’t work in all situations (eg in order by - GroupBySelectCaseTest.selectCaseInOrderByAndSelectExpression() and comparisons against a parameters - SelectCaseLiteralHandlingBindTest.whereCaseExpression())

Assignee

Unassigned

Reporter

Guillaume Smet

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Major
Configure