Description Björn Clemens 2011-05-17 11:58:26 EDT

Build Identifier: 2.2.0.v20110202-r8913

environment: optional - many to one-relation between two tables
task: select all elements on many-table what are not mapped to target table (ref_id column contains null value)

the following code returns no result, even if matching values are available in table

CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<AnyMappedObject> criteriaQuery = builder.createQuery(AnyMappedObject.class);
Root<AnyMappedObject> entity_ = criteriaQuery.from(AnyMappedObject.class);
criteriaQuery.where(entity_.get("target").isNull());

TypedQuery<AnyMappedObject> entityQuery = entityManager.createQuery(criteriaQuery);
List<AnyMappedObject> results = entityQuery.getResultList();

Case 1: bidirectional mapping via join-column/inverse-join-column 

generated sql: SELECT t1.ID, t1.anyAttribute FROM TargetTable  t0, SourceTable  t1 WHERE (NOT EXISTS (SELECT t4.ID FROM TargetTable t5, SourceTable t4 WHERE (t5.targetId = t1.ID))  AND ((t0.targetId  = t1.ID) AND (t0.ID = t0.ID)))

expected sql: SELECT t0.anyAttribute FROM AnyMappedObjectTable t0 WHERE  t0.targetId is null

case 2: unidirectional mapping

generated sql: SELECT t1.ID, t1.anyAttribute FROM TargetTable t0, SourceTable t1 WHERE ((t1.targetId IS NULL) AND (t0.ID = t1.targetId))

expected sql: SELECT t1.ID, t1.anyAttribute FROM SourceTable t1 WHERE t1.targetId is null

Reproducible: Always

Steps to Reproduce:
1.see details