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

Class org.apache.derbyTesting.junit.RuntimeStatisticsParser

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

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

                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

        rs.next();
        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            rs.close();
            if (expectedScan.equals("Table"))
                    assertTrue(rtsp.usedTableScan());
            else if (expectedScan.equals("Index"))
            {
                assertTrue(rtsp.usedIndexScan());
                assertTrue(rtsp.usedSpecificIndexForIndexScan(
                        expTableInIndexScan, expIndexInIndexScan));

View Full Code Here

        "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

        rs.next();


        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            rs.close();
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        
        st.close();
    }

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
        // nested loop exists join, right side should be 
        // ProjectRestrict on index scan with start and stop keys

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
        // hash exists join, right side PR on hash index scan, no 
        // start/stop key, next qualifier "=".

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
        // hash exists join, right side PR on hash index scan, 
        // still no start/stop key, next qualifier "=". It still

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
       st.executeUpdate(
            " create index i12 on t1 (c1, c2)");

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
        // just some more tests in different situations, not for 
        // the bug 4316 many items

View Full Code Here

       rs.next();


       if(usingEmbedded()){
           RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
           rs.close();
           assertTrue(rtsp.usedTableScan());
           assertFalse(rtsp.usedDistinctScan());
       }
        
       st.executeUpdate(
            " create index i12 on t1 (c1, c2)");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.