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();
   }



Reply via email to