List of usedTableScan() Examples

Examples of usedTableScan()

org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()
Return whether or not a Table Scan result set was used in the query.

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

        "AND m1.value='21857' ORDER BY m0.value";


        s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        ResultSet rs = s.executeQuery(sql1);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedTableScan("TABLE2"));
    assertTrue(rtsp.whatSortingRequired());


        rs = s.executeQuery(sql1);
        String[][] result = {
                {"4294967297", "000001", "21857"},

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()


        s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        ResultSet rs = s.executeQuery(sql1);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedSpecificIndexForIndexScan("TABLE2","KEY3"));
    assertTrue(rtsp.usedTableScan("TABLE1"));
    assertTrue(rtsp.whatSortingRequired());
  
        rs = s.executeQuery(sql1);
        String[][] result = {
                {"4294967297", "000001", "21857"},

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

    s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        ResultSet rs = s.executeQuery(sql1);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(
        s);
    assertTrue(rtsp.usedSpecificIndexForIndexScan("TABLE2","KEY3"));
    assertTrue(rtsp.usedTableScan("TABLE1"));
    assertTrue(rtsp.whatSortingRequired());


    rs = s.executeQuery(sql1);
        String[][] result = {
                {"4294967297", "000001", "21857"},

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

                       {"11", "hhhh"},
                 {"12", "rrrr"} };                     
    stmt.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");      
    JDBC.assertFullResultSet(stmt.executeQuery("select i, b from t3 FOR UPDATE"), expectedValues);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(stmt);
    assertTrue(rtsp.usedTableScan());
    assertFalse(rtsp.usedDistinctScan());
    commit();


    PreparedStatement p = prepareStatement("select i, b from t3  where i = ? FOR UPDATE");
                p.setString(1, "7");

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

                p.setString(1, "7");
                p.executeQuery();
    String [][] expectedValues1 = { {"7", "iiii" } };
    JDBC.assertFullResultSet(p.getResultSet(), expectedValues1);
    RuntimeStatisticsParser rtsp2 = SQLUtilities.getRuntimeStatisticsParser(stmt);
    assertFalse(rtsp2.usedTableScan());
    assertFalse(rtsp2.usedDistinctScan());
    p.close();
    commit();

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

            {"4", "aaaa" },
            {"5", "jjjj" },
            {"6", "rrrr" } };
    JDBC.assertFullResultSet(p.getResultSet(), expectedValues2);
    RuntimeStatisticsParser rtsp3 = SQLUtilities.getRuntimeStatisticsParser(stmt);
    assertFalse(rtsp3.usedTableScan());
    assertFalse(rtsp3.usedDistinctScan());              
    p.close();
    commit();

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

                p.setString(1, "cccc");
                p.executeQuery();
    String[][] expectedValues3 = { {"10", "cccc" } };
    JDBC.assertFullResultSet(p.getResultSet(), expectedValues3);
    RuntimeStatisticsParser rtsp4 = SQLUtilities.getRuntimeStatisticsParser(stmt);
    assertFalse(rtsp4.usedTableScan());
    assertFalse(rtsp4.usedDistinctScan());
    p.close();
    commit();


          stmt.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0)");

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

            {
                // not sure why I get a null rts with network server.
                RuntimeStatisticsParser rts = new RuntimeStatisticsParser(rs2.getString(1));
                rs2.close();
                assertEquals(Connection.TRANSACTION_READ_COMMITTED, rts.getIsolationLevel());
                assertTrue(rts.usedTableScan());
                assertTrue(rts.isScrollInsensitive());
            }
         
            rs.close();  
            ps_c1.close();

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()

        "AND m1.value='21857' ORDER BY m0.value";


        s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        ResultSet rs = s.executeQuery(sql1);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedTableScan("TABLE2"));
    assertTrue(rtsp.whatSortingRequired());


        rs = s.executeQuery(sql1);
        String[][] result = {
                {"4294967297", "000001", "21857"},

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedTableScan()


        s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        ResultSet rs = s.executeQuery(sql1);
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedSpecificIndexForIndexScan("TABLE2","KEY3"));
    assertTrue(rtsp.usedTableScan("TABLE1"));
    assertTrue(rtsp.whatSortingRequired());
  
        rs = s.executeQuery(sql1);
        String[][] result = {
                {"4294967297", "000001", "21857"},

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.