"where t1.twenty = s.twenty " +
"and s.hundred = CAST(CHAR(t1.hundred) AS INTEGER)").close();
checkEstimatedRowCount(conn,160400.2500000);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.usedSpecificIndexForIndexScan("T1", "T1_TWENTY_HUNDRED"));
assertTrue(rtsp.usedHashJoin());
}
public void testStatMatcher() throws SQLException {
// test of statistics matcher algorithm; make sure that we choose the
// best statistics (the weight stuff in predicatelist)