);
}
@Test(groups=KNOWN_BUG, description="broken")
public void fullTreeOfNestedSubqueriesWithAnd() throws TranslationException {
final Term expected_sub_2 = filter(cartProd(cartProd(
rel("q",1),
ref("q")),
ref("q")),"AND(q0.a>q1.a,q0.a>q2.a)");
String sub_2 = "SELECT * FROM q q2 WHERE q0.a > q1.a AND q0.a > q2.a";
Term expected_sub_1 = genJoin(genJoin(cartProd(
ref("q"),
ref("q")),expected_sub_2,"NATURALJOIN"),expected_sub_2,"NATURALJOIN");
String sub_1 = String.format("SELECT * FROM q q1 WHERE EXISTS (%s) AND EXISTS (%s)", sub_2, sub_2);
Term expected_0 = genJoin(genJoin(ref("q"),expected_sub_1,"NATURALJOIN"),expected_sub_1,"NATURALJOIN");
String query = String.format("SELECT * FROM q q0 WHERE EXISTS (%s) AND EXISTS (%s)", sub_1, sub_1);
assertThat(query).translatesLike(expected_0);
}