Message Title

Nikita Metzger created an issue

Issue Type:	Bug
Affects Versions:	5.2.0
Assignee:	Unassigned
Components:	hibernate-entitymanager
Created:	13/Jun/2016 07:34 AM
Priority:	Major
Reporter:	Nikita Metzger

Using concat inside a case clause leads to QuerySyntaxException: unexpected token: ||

 
                                                                CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<SomeEntity> c = cb.createQuery(SomeEntity.class);
Root<SomeEntity> r = c.from(SomeEntity.class);
c.multiselect(cb.selectCase().when(cb.isNotNull(r.get("someprop")), cb.concat("A", "B"))
                .otherwise(cb.concat("C", "D"))));
....
 
                                                            

It compiles in HQL like:

 
                                                                select case when generatedAlias0.someprop is not null then 'A' || 'B' else 'C' || 'D' end from SomeEntity as generatedAlias0

It looks like 'A' || 'B' expression should be wrapped with brackets, while using HQL directly with wrapped value(i.e. ('A' || 'B')) works properly.

Add Comment

This message was sent by Atlassian JIRA