// 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 >= 200 and e1 < 207");
test.assertRowCount(5);
test.execute("select * from g2 where e1 >= 200 and e1 < 207");
test.assertRowCount(5);
test.execute("select distinct e2 from g1 where e1 >= 200 and e1 < 207");
test.assertResultsSetEquals(new String[] {"e2[varchar2]", "blah"});
}