[OPENJPA-2861] select sum(CASE x WHEN x THEN 1 ELSE 0 ) returns String instead of Long.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 3.2.0
• Component/s: kernel
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 06/Apr/21 14:51
• Updated: 14/May/21 08:16
• Resolved: 06/Apr/21 20:33

Description

It seems that a few operations in JDBCExpressionFactory often calls getLiteralRawString which destroys the information about any real types in a query and replaces it with a Raw which is always of type java.lang.String.

This breaks the following query, which wrongly returns a string instead of a Long:

final TypedQuery<Long> q 
   = em.createQuery("select SUM(CASE ae.stringVal WHEN 'bare' THEN 1 ELSE 0 END) from AggEntity AS ae", Long.class);
final Long sumC = q.getSingleResult();

This only affects us since I fixed UnaryOp to not return the native JDBC vendor type of a given column but uses the val.getType()