Message Title

Nikita Metzger created an issue

Issue Type:	Bug
Affects Versions:	5.2.0
Assignee:	Unassigned
Components:	hibernate-entitymanager
Created:	14/Jun/2016 03:44 AM
Environment:	DB: Informix. Dialect: InformixDialect. EntityManager: org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean v.4.3.0.RELEASE with org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter
Priority:	Major
Reporter:	Nikita Metzger

Using the same clause

 
                                                                cb.trim(cb.concat(".",cb.literal("Test   ")))

in selectCase and outside behaves different.

So using such query:

 
                                                                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.trim(cb.concat(".",cb.literal("Test   "))))), cb.trim(cb.concat(".",cb.literal("Test   "))));
....
 
                                                            

The output result will be something like:

 
                                                                ".Test                                                       ",".Test"

So the value in selectCase will not be trimmed.

Add Comment

This message was sent by Atlassian JIRA