// run test
getTransactionContainter().runTransaction(userTxn);
// now verify the results
AbstractQueryTest test = new QueryExecution(userTxn.getSource("pm1")) {
protected boolean compareCaseSensitive() {
return false;
}
};
test.execute("select * from g1 where e1 >= 100 and e1 < 115");
test.assertRowCount(15);
test.execute("select * from g2 where e1 >= 100 and e1 < 115");
test.assertRowCount(15);
test.execute("select distinct e2 from g1 where e1 > 100");
// NOTE: if this is an oracle source, it failes because it return varchar2
if (userTxn.getSource("pm1").getMetaData().getDatabaseProductName().toLowerCase().indexOf("oracle") > -1) {
test.assertResultsSetEquals(new String[] {"e2[varchar2]", "blah"});
} else {
test.assertResultsSetEquals(new String[] {"e2[varchar]", "blah"});
}
}