@Test
public void testInsertBySelect() throws SQLException {

    SqlBuilder builder = SqlBuilder.insertInto(p);
    builder.append(SqlBuilder.select(p.Name).from(p).where().allOf(p.Name.eq(1), p.CountryID.gt(2)));
    ConditionList cl = builder.buildUpdateConditions();
    assertTrue(cl.isIntersected());
    assertEquals(2, cl.size());
}