switch(obj.getJoinType()) { case CROSS_JOIN: buffer.append(CROSS); if(rightItem instanceof Join && (useParensForJoins() || obj.getJoinType() == Join.JoinType.CROSS_JOIN)) { buffer.append(Tokens.LPAREN); append(rightItem);
public static void convertCrossJoinToInner(LanguageObject obj, LanguageFactory lf) { if (obj instanceof Join) { Join join = (Join)obj; if (join.getJoinType() == JoinType.CROSS_JOIN) { Literal one = lf.createLiteral(1, TypeFacility.RUNTIME_TYPES.INTEGER); join.setCondition(lf.createCompareCriteria(Operator.EQ, one, one)); join.setJoinType(JoinType.INNER_JOIN); } } }
JoinTable join = handleJoin(obj.getJoinType(), left, right, obj.getCondition(), true); this.joins.add(join); return join; leftJoin = handleJoin((Join)left); if (right instanceof NamedTable) { JoinTable join = handleJoin(obj.getJoinType(), leftJoin, (NamedTable)right, obj.getCondition()); this.joins.add(join); return join; rightJoin = handleJoin((Join)right); if (left instanceof NamedTable) { JoinTable join = handleJoin(obj.getJoinType(), (NamedTable)left, rightJoin, obj.getCondition()); this.joins.add(join); return join;
public void testGetJoinType() throws Exception { assertEquals(Join.JoinType.CROSS_JOIN, example(JoinType.JOIN_CROSS).getJoinType()); assertEquals(Join.JoinType.FULL_OUTER_JOIN, example(JoinType.JOIN_FULL_OUTER).getJoinType()); assertEquals(Join.JoinType.INNER_JOIN, example(JoinType.JOIN_INNER).getJoinType()); assertEquals(Join.JoinType.LEFT_OUTER_JOIN, example(JoinType.JOIN_LEFT_OUTER).getJoinType()); assertEquals(Join.JoinType.RIGHT_OUTER_JOIN, example(JoinType.JOIN_RIGHT_OUTER).getJoinType()); }
TableReference leftItem = obj.getLeftItem(); TableReference rightItem = obj.getRightItem(); JoinType joinType = obj.getJoinType(); if(rightItem instanceof Join && (useParensForJoins() || obj.getJoinType() == Join.JoinType.CROSS_JOIN)) { buffer.append(Tokens.LPAREN); append(hasLateralJoin(rightItem)?unwrap(rightItem):rightItem);
@Override public void visit(Join obj) { try { if (obj.getLeftItem() instanceof Join) { append(obj.getLeftItem()); Table right = ((NamedTable)obj.getRightItem()).getMetadataObject(); processJoin(this.mongoDoc, new MongoDocument(right, this.metadata), obj.getCondition(), obj.getJoinType()); } else if (obj.getRightItem() instanceof Join) { Table left = ((NamedTable)obj.getLeftItem()).getMetadataObject(); append(obj.getRightItem()); processJoin(this.mongoDoc, new MongoDocument(left, this.metadata), obj.getCondition(), obj.getJoinType()); } else { Table left = ((NamedTable)obj.getLeftItem()).getMetadataObject(); Table right = ((NamedTable)obj.getRightItem()).getMetadataObject(); processJoin(new MongoDocument(left, this.metadata), new MongoDocument(right, this.metadata), obj.getCondition(), obj.getJoinType()); } } catch (TranslatorException e) { this.exceptions.add(e); } }
Table right = ((NamedTable)obj.getRightItem()).getMetadataObject(); try { updated = this.odataQuery.addNavigation(obj.getCondition(), obj.getJoinType(), right); obj.setCondition(updated); if (updated != null) { Table left = ((NamedTable)obj.getLeftItem()).getMetadataObject(); try { updated = this.odataQuery.addNavigation(obj.getCondition(), obj.getJoinType(), left); obj.setCondition(updated); if (updated != null) { throw new TranslatorException(ODataPlugin.Util.gs(ODataPlugin.Event.TEIID17027, left.getName())); updated = this.odataQuery.addNavigation(obj.getCondition(), obj.getJoinType(), left, right); obj.setCondition(updated); if (updated != null) {
if (join.getJoinType() == JoinType.INNER_JOIN) { if (!isChildToParentJoin()) {
/** * only a single join predicate is supported, so move up conditions if possible */ private void moveCondition(Select select, TableReference tableReference) { if (!(tableReference instanceof Join)) { return; } Join join = (Join)tableReference; if (join.getJoinType() != JoinType.INNER_JOIN) { return; } while (join.getCondition() instanceof AndOr) { AndOr andOr = (AndOr) join.getCondition(); if (andOr.getOperator() == AndOr.Operator.OR) { break; } Condition c = andOr.getLeftCondition(); select.setWhere(LanguageUtil.combineCriteria(select.getWhere(), c, getLanguageFactory())); join.setCondition(andOr.getRightCondition()); } moveCondition(select, join.getLeftItem()); moveCondition(select, join.getRightItem()); } }