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

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

        
        expRS = new String[][] { { "1", "2", "2", "2" }, { "2", "4", "4", "4" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        RuntimeStatisticsParser p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());


        rs = st.executeQuery("select * from V2, V1 where V1.j = V2.b");


        expColNames = new String[] { "A", "B", "I", "J" };

View Full Code Here

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


        expRS = new String[][] { { "2", "2", "1", "2" }, { "4", "4", "2", "4" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());


        // Nested unions.


        rs = st

View Full Code Here

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

                { "4", "-8", "4", "4" }, { "4", "-8", "4", "16" },
                { "4", "8", "4", "4" }, { "4", "8", "4", "16" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());




        rs = st
                .executeQuery("select * from (select * from t1 union all select * "

View Full Code Here

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

                { "3", "6", "3", "12" }, { "4", "-8", "4", "4" },
                { "4", "-8", "4", "16" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());


        rs = st
                .executeQuery("select * from (select * from t1 union select * from "
                        + "t2) x1, (select * from t3 union all select * from "

View Full Code Here

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

                { "4", "-8", "4", "4" }, { "4", "-8", "4", "16" },
                { "4", "8", "4", "4" }, { "4", "8", "4", "16" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());




        rs = st
                .executeQuery("select * from (select * from t1 union all select * "

View Full Code Here

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

                { "3", "6", "3", "12" }, { "4", "-8", "4", "4" },
                { "4", "-8", "4", "16" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan", p.usedTableScan());
        assertTrue("Expected hash join", p.usedHashJoin());


        // Next set of queries tests pushdown of predicates whose
        // column references do not reference base tables--ex. they
        // reference literals, aggregates, or subqueries. We don't

View Full Code Here

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

        expRS = new String[][] { { "404" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        
        p = SQLUtilities.getRuntimeStatisticsParser(st);  
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected table scan on T4", p.usedTableScan("T4"));
      
        rs = st.executeQuery("select count(*) from V1, V2 where V1.j > 0");


        expColNames = new String[] { "1" };

View Full Code Here

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


        JDBC.assertFullResultSet(rs, expRS, true);
        
        p = SQLUtilities.getRuntimeStatisticsParser(st);  
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected table scan on T4", p.usedTableScan("T4"));
      
        rs = st.executeQuery("select count(*) from V1, V2 where V1.j > 0");


        expColNames = new String[] { "1" };
        JDBC.assertColumnNames(rs, expColNames);

View Full Code Here

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

        expRS = new String[][] { { "505" } };


        JDBC.assertFullResultSet(rs, expRS, true);
     
        p = SQLUtilities.getRuntimeStatisticsParser(st);  
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected table scan on T4", p.usedTableScan("T4"));
      
        // Combination of join predicate and non-join predicate:
        // the join predicate should be pushed to V2 (T3 and T4),
        // the non-join predicate should operate as usual.

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.