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.

        expColNames = new String[] { "I", "J", "A", "B" };
        JDBC.assertColumnNames(rs, expColNames);
 
        JDBC.assertEmpty(rs);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Pushing predicates should still work even if user

View Full Code Here

        JDBC.assertColumnNames(rs, expColNames);
 
        JDBC.assertEmpty(rs);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Pushing predicates should still work even if user
        // specifies explicit column names. In these two queries

View Full Code Here

 
        JDBC.assertEmpty(rs);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Pushing predicates should still work even if user
        // specifies explicit column names. In these two queries
        // we push to X2 (T3 and T4).

View Full Code Here

        JDBC.assertEmpty(rs);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Pushing predicates should still work even if user
        // specifies explicit column names. In these two queries
        // we push to X2 (T3 and T4).

View Full Code Here

        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        // DERBY-3819 - this test case consistently fails for 64 bit
        // temporarily (until 3819 is fixed by changing the queries with optimizer directives)
        if (!is64BitJVM()) {
            assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
            assertTrue("Expected Hash Join",p.usedHashJoin());
        }


        // If we
        // have nested unions, the predicate should get pushed all

View Full Code Here

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


        JDBC.assertFullResultSet(rs, expRS, true);
        
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Predicate pushdown should work with explicit use of

View Full Code Here


        JDBC.assertFullResultSet(rs, expRS, true);
        
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Predicate pushdown should work with explicit use of
        // "inner join" just like it does for implicit join. So

View Full Code Here

        JDBC.assertFullResultSet(rs, expRS, true);
        
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Predicate pushdown should work with explicit use of
        // "inner join" just like it does for implicit join. So
        // should see index scans on T3 and T4.

View Full Code Here

        
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected Table Scan ResultSet for T1", p.usedTableScan("T1"));
        assertTrue("Expected Table Scan ResultSet for T2", p.usedTableScan("T2"));
        assertTrue("Expected Table Scan ResultSet for T3", p.usedTableScan("T3"));
        assertTrue("Expected Table Scan ResultSet for T4", p.usedTableScan("T4"));
  
        // Predicate pushdown should work with explicit use of
        // "inner join" just like it does for implicit join. So
        // should see index scans on T3 and T4.

View Full Code Here

                { "4", "4", "4", "5" }, { "4", "4", "4", "16" },
                { "4", "8", "4", "4" }, { "4", "8", "4", "5" },
                { "4", "8", "4", "16" }, { "5", "10", "5", "6" }};
        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        
        // Make sure optimizer is still considering predicates for
        // other, non-UNION nodes. Here we should use the

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.