l2.setAlias("B");
plan.add(l2);
MultiMap<Integer, LogicalExpressionPlan> joinPlans = new MultiMap<Integer, LogicalExpressionPlan>();
LogicalRelationalOperator j1 = new LOJoin(plan, joinPlans, LOJoin.JOINTYPE.HASH, new boolean[]{true, true});
LogicalExpressionPlan p1 = new LogicalExpressionPlan();
ProjectExpression lp1 = new ProjectExpression(p1, 0, 1, j1);
p1.add(lp1);
joinPlans.put(0, p1);
LogicalExpressionPlan p2 = new LogicalExpressionPlan();
ProjectExpression lp2 = new ProjectExpression(p2, 1, 1, j1);
p2.add(lp2);
joinPlans.put(1, p2);
j1.setAlias("C");
plan.add(j1);
// build an expression with no AND
LogicalExpressionPlan p3 = new LogicalExpressionPlan();
LogicalRelationalOperator f1 = new LOFilter(plan, p3);