@Test
public void testSelectWhereExcludeAll() throws SQLException {

    SqlBuilder builder = SqlBuilder.selectAllFrom(p).where().excludeAll().and().append(p.CityID.eq(1), OR, p.CountryID.eq(1), AND, p.Name.like("A"), OR, p.PeopleID.eq(1));
    ConditionList cl = builder.buildQueryConditions();
    cl = (ConditionList)cl.get(0);//get first
    assertFalse(cl.isIntersected());
    assertEquals(4, cl.size());
    assertTrue(cl.get(0) instanceof ColumnCondition);
    cl = (ConditionList)cl.get(2);
    assertTrue(cl.isIntersected());
    assertEquals(2, cl.size());
}