[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5118) Criteria not generating whole SQL (missing select, missing join)

[ChB (JIRA)]

Criteria not generating whole SQL (missing select, missing join)
----------------------------------------------------------------

                 Key: HHH-5118
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5118
             Project: Hibernate Core
          Issue Type: Bug
    Affects Versions: 3.5.1
            Reporter: ChB
            Priority: Critical


I use the following code:

class X {
	@ManyToMany(mappedBy = "x")
	public Set<Y> getY() {
		return this.y;
	}
}

class Y {
	@ManyToMany(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY)
	@JoinTable(name = "x_to_y", joinColumns = { @JoinColumn(name = "y") }, inverseJoinColumns = { @JoinColumn(name = "x") })
	public Set<X> getX() {
		return this.x;
	}

	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "y_to_z", joinColumns = { @JoinColumn(name = "y") }, inverseJoinColumns = { @JoinColumn(name = "z") })
	@OrderBy("name ASC")
	public List<Z> getZ() {
		return this.z;
	}
}

class Z {
	@ManyToMany(mappedBy = "z", cascade = CascadeType.ALL)
	public Set<Y> getY() {
		return this.y;
	}

	@ManyToMany(fetch = FetchType.LAZY, mappedBy = "broken")
	public Set<Broken> getBroken() {
		return this.broken;
	}
}

class Broken {
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "z_to_broken", joinColumns = { @JoinColumn(name = "broken") }, inverseJoinColumns = { @JoinColumn(name = "z") })
	@OrderBy("name ASC")
	public List<Z> getZ() {
		return this.z;
	}
}

And perform the following criteria query:

Criteria criteria = session.createCriteria(X.class);
Criteria criteriaY = criteria.createCriteria("y");
Criteria criteriaZ = criteriaY.createCriteria("z");
Criteria criteriaBroken = criteriaZ.createCriteria("broken");
criteriaBroken.add(Restrictions.eq("id", 1));


This results in the following SQL


select this_.id as id14_4_,
 this_.* as ...,
 x_to_y5_.x as x2_14_,
 y1_.id as y,
 y1_.id as id3_0_,
 y1_.* as ...,
 z9_.y as y1_3_,
 z2_.id as z2_,
 z2_.id as id19_3_,
 z2_.* as ...,
from y this_
inner join x_to_y x_to_y5_ on this_.id=x_to_y5_.x
left outer join y y1_ on x_to_y5_.y=y1_.id
inner join y_to_z z9_ on y1_.id=z9_.y_id
left outer join z z2_ on z9_.z=z2_.id
inner join z_to_broken broken11_ on z2_.id=broken11_.z
where broken3_.id=1


There are 2 errors in the SQL which might come down to the same issue:

1.) In the select clause right before the 'from y this_' is a ',' which shows that not all columns where put in the select clause.
2.) In the where clause a 'broken3_' is used which was never declared before.


This works fine in Hibernate 3.3.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira