The test below fails in DynamicLikeOptimizationTest. I wonder is this
optimization expected for
TERRITORY_BASED collation or is ok that it is not done.
Kathey
/**
* Test that dynamic like optimization is performed. That is, the LIKE
* predicate is rewritten to >=, < and LIKE.
*/
public void testDynamicLikeOptimization() throws SQLException {
Statement s = createStatement();
s.execute("CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
PreparedStatement ps =
prepareStatement("select id from test where vc10 like ?");
ps.setString(1, "%");
JDBC.assertDrainResults(ps.executeQuery());
RuntimeStatisticsParser p =
SQLUtilities.getRuntimeStatisticsParser(s);
*assertTrue(p.hasGreaterThanOrEqualQualifier());* <-- FAILS HERE
assertTrue(p.hasLessThanQualifier());
s.close();
ps.close();
}