LogicalExpressionPlan filterPlan = new LogicalExpressionPlan();
ProjectExpression namePrj2 = new ProjectExpression(filterPlan, DataType.CHARARRAY, 0, 0);
filterPlan.add(namePrj2);
ConstantExpression constExp = new ConstantExpression(filterPlan, DataType.CHARARRAY, "joe");
filterPlan.add(constExp);
EqualExpression equal = new EqualExpression(filterPlan, namePrj2, constExp);
filterPlan.add(equal);
filter.setFilterPlan(filterPlan);
filter.setAlias("C");
plan.add(filter);
LOFilter filter2 = new LOFilter(plan);
LogicalExpressionPlan filter2Plan = new LogicalExpressionPlan();
ProjectExpression name2Prj2 = new ProjectExpression(filter2Plan, DataType.CHARARRAY, 0, 0);
filter2Plan.add(name2Prj2);
ConstantExpression const2Exp = new ConstantExpression(filter2Plan, DataType.CHARARRAY, "joe2");
filter2Plan.add(const2Exp);
EqualExpression equal2 = new EqualExpression(filter2Plan, namePrj2, constExp);
filter2Plan.add(equal2);
filter2.setFilterPlan(filter2Plan);
filter2.setAlias("C1");
plan.add(filter2);