public void testBuildIn() {
Object[][] data = { //
{new String[] {"a", "b", "c"}, "(f IN ('a','b','c'))"}, //
{new String[] {"a", "b", null}, "((f IN ('a','b')) OR (f IS NULL))"}, //
};
for (int i = 0; i < data.length; i++) {
ISQLLogic logic = SQLLogicBuilder.buildIn("f", DataTypes.STRING, (Object[]) data[i][0]);
String strSQL = logic.toSQL(null);
System.out.println("[" + i + "]SQL=" + strSQL);
assertEquals((String) data[i][1], strSQL);
}
}
