I have an Idea project with a Spring facet and a Hibernate facet. There is no JPA facet in the project.

Idea's Persistence QL inspection highlights red any usage of case when ... then ... else ... end as "Can't resolve expression".

h4. Repro

Simple:

Query q = getSession().createQuery("select case when f.bar > 0 then 1 else 0 end from Foo f");

More complicated (inside another expression):

Query q = getSession().createQuery("select sum(case when f.bar > 0 then 1 else 0 end) from Foo f group by f.baz desc");

h4. Workaround

The only workaround I could find was to disable Persistence QL inspection on the entire statement:

//noinspection JpaQlInspection
Query q = getSession().createQuery("select case when f.bar > 0 then 1 else 0 end from Foo f");

Which is sad because I find the persistence QL error inspection to be very helpful 99% of the time.

h4. Notes

• http://docs.jboss.org/hibernate/stable/core/reference/en/html/queryhql-expressions.html

Environment: Spring 2.5.6, Hibernate 3.2.6 GA
Idea project has Spring facet and Hibernate facet

Issue was resolved