I am trying to use 'case when then' in a sql select, but the parser mistakes it for an alias. I see in the release notes for 3.0.4 (23.5.2005) that this should be possible:

* [HHH-467] - HQL: support for case when then else end IN select clause

Hibernate version: 3.1.2
Code between sessionFactory.openSession() and session.close():
String hql = "select "
//+ " ap.endDate "
+ " case when ap.endDate = 0 then 99999999 when ap.endDate != 0 then ap.endDate end "
//+ " case ap.endDate when 0 then 99999999 else ap.endDate end "
+ " from TargetTable ap ";
Full stack trace of any exception that occurs:
org.hibernate.QueryException: undefined alias: case [select case when ap.endDate = 0 then 99999999 when ap.endDate != 0 then ap.endDate end from com.alldata.ecis.persistence.AccountAgreementPremises ap ]
at org.hibernate.hql.classic.PathExpressionParser.token(PathExpressionParser.java:130)
Name and version of the database you are using: db2 as400

Ben - I tried similar query on IBM DB2 and "case" seems to work, you might have a type mismatch issue.



Jeevs