for (int i = components.size() - 1; i >= 0; i--) {
AmberExpr component = components.get(i);
if (component instanceof JoinExpr) {
JoinExpr link = (JoinExpr) component;
if (link.bindToFromItem()) {
components.remove(i);
}
}
}
_where = and.getSingle();
}
if (_having instanceof AndExpr) {
AndExpr and = (AndExpr) _having;
ArrayList<AmberExpr> components = and.getComponents();
for (int i = components.size() - 1; i >= 0; i--) {
AmberExpr component = components.get(i);
if (component instanceof JoinExpr) {
JoinExpr link = (JoinExpr) component;
if (link.bindToFromItem()) {
components.remove(i);
}
}
}
_having = and.getSingle();
}
// Rolls up unused from items from the left to the right.
// It's not necessary to roll up the rightmost items because
// they're only created if they're actually needed
for (int i = 0; i < _fromList.size(); i++) {
FromItem item = _fromList.get(i);
JoinExpr join = item.getJoinExpr();
if (join == null)
continue;
// XXX: jpa/1173, jpa/1178
// if (getParentQuery() != null)
// break;
FromItem joinParent = join.getJoinParent();
FromItem joinTarget = join.getJoinTarget();
boolean isTarget = item == joinTarget;
if (joinParent == null) {
}
else if (joinParent.getJoinExpr() == null
&& joinParent == joinTarget
&& ! usesFromData(joinParent)) {
_fromList.remove(joinParent);
replaceJoin(join);
// XXX:
item.setJoinExpr(null);
//item.setOuterJoin(false);
i = -1;
AmberExpr joinWhere = join.getWhere();
if (joinWhere != null)
_where = AndExpr.create(_where, joinWhere);
}
else if (item == joinTarget
&& ! isJoinParent(item)
&& ! usesFromData(item)) {
boolean isManyToOne = false;
boolean isManyToMany = false;
if (join instanceof ManyToOneJoinExpr) {
// jpa/0h1c
isManyToOne = true;
// jpa/1144
ManyToOneJoinExpr manyToOneJoinExpr;
manyToOneJoinExpr = (ManyToOneJoinExpr) join;
isManyToMany = manyToOneJoinExpr.isManyToMany();
}
// ejb/06u0, jpa/1144, jpa/0h1c, jpa/114g
if (isManyToMany || (isManyToOne && ! item.isInnerJoin())) {
// ejb/06u0 || isFromInnerJoin(item)))) {
// Optimization for common children query:
// SELECT o FROM TestBean o WHERE o.parent.id=?
// jpa/0h1k
// jpa/114g as negative exists test
// jpa/0h1m
if (i + 1 < _fromList.size()) {
FromItem subItem = _fromList.get(i + 1);
JoinExpr nextJoin = subItem.getJoinExpr();
if (nextJoin != null
&& nextJoin instanceof ManyToOneJoinExpr) {
continue;
}