Message Title

Adam Walczak - WALCZAK.IT created an issue

HHH-8766

Issue Type:	Bug
Affects Versions:	4.2.3
Assignee:	Unassigned
Components:	query-hql
Created:	04/Dec/13 6:09 AM
Environment:	walec51@walec51-linux:~$ java -version java version "1.8.0-ea" Java(TM) SE Runtime Environment (build 1.8.0-ea-b118) Java HotSpot(TM) 64-Bit Server VM (build 25.0-b60, mixed mode)
Priority:	Critical
Reporter:	Adam Walczak - WALCZAK.IT

This query didn't work:

– A –

 
                                                    SELECT c FROM MainDynamicClass c WHERE TYPE(c) = ?1
AND (c.dynamicSuperclass IS NULL OR TYPE(c.dynamicSuperclass) != ?1)

it returned an empty result - but the equivalent query below did work:

– B –

 
                                                    SELECT c FROM MainDynamicClass c LEFT JOIN c.dynamicSuperclass sc WHERE TYPE(c) = ?1 AND (c.dynamicSuperclass IS NULL OR TYPE(sc) != ?1)

It seams that Hibernate handles the TYPE operator on a attribute (that in may case is of the same class as the root query class) in a bizarre way. Below is a translation of the query A to SQL:

 
                                                    select maindynami0_.id as id2_1_, maindynami0_.code as code3_1_, maindynami0_.hierarchyPath as hierarch4_1_, maindynami0_.name as name5_1_, maindynami0_.dynamicSuperclass_id as dynamicS6_1_, maindynami0_.DTYPE as DTYPE1_1_
from DynamicClass maindynami0_ where maindynami0_.DTYPE in ('InstitutionDynamicClass', 'CompanyDynamicClass', 'OrganizationDynamicClass', 'PersonDynamicClass', 'LegalEntityDynamicClass')
and maindynami0_.DTYPE=? and (maindynami0_.dynamicSuperclass_id is null or maindynami0_.DTYPE<>?)

the c.dynamicSuperclass attribute is nether joined in this query and TYPE(c.dynamicSuperclass) is actually treated as TYPE(c).

Add Comment

This message was sent by Atlassian JIRA