Package org.apache.derbyTesting.junit

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

814
815
816
817
818
819
820
821
822
823
824
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    assertRowCount(1, s.executeQuery("select distinct c2, c1 from t1 where c3 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    assertRowCount(1, s.executeQuery("select distinct c2 from t1 where c3 = '1' and c1 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here
819
820
821
822
823
824
825
826
827
828
829
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    assertRowCount(1, s.executeQuery("select distinct c2 from t1 where c3 = '1' and c1 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    // ordered, but no where clause - uses distinct scan
    // the following approach is used because the ordering of the results from
    // the distinct is not guaranteed (it varies depending on the JVM hash
View Full Code Here
833
834
835
836
837
838
839
840
841
842
843
    // file for all JVM's.
   
    s.execute("create table temp_result (result_column int)");
    s.execute("insert into temp_result (select distinct c1 from t1)");
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedDistinctScan());
    assertRowCount(4, s.executeQuery("select * from temp_result order by result_column"));
   
    // test distinct with an order by
    assertRowCount(4, s.executeQuery("select distinct c1 from t1 order by c1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here
839
840
841
842
843
844
845
846
847
848
849
    assertRowCount(4, s.executeQuery("select * from temp_result order by result_column"));
   
    // test distinct with an order by
    assertRowCount(4, s.executeQuery("select distinct c1 from t1 order by c1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());   
   
      s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0)");
      s.execute("drop table temp_result");
    s.execute("drop table t1");
View Full Code Here
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
        rs.next();
       
        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();
       
        rs = st.executeQuery(
            " select * from tt1 left outer join tt2 on tt1.c1 = "
View Full Code Here
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
        rs.next();
       
        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();

        rs = st.executeQuery(
            " select * from tt1 left outer join tt2 on tt1.c1 = "
View Full Code Here
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
        rs.next();

        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();
       
        rs = st.executeQuery(
            " select * from tt2 right outer join tt1 on tt1.c1 = "
View Full Code Here
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
        rs.next();

        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();
       
        rs = st.executeQuery(
            " select * from tt1 left outer join tt2 on tt1.c1 = "
View Full Code Here
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
        rs.next();

        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();
       
        rs = st.executeQuery(
            " select * from tt1 left outer join tt2 on tt1.c1 = "
View Full Code Here
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
        rs.next();

        if(usingEmbedded()){
            RuntimeStatisticsParser rtsp = new RuntimeStatisticsParser(rs.getString(1));
            assertTrue(rtsp.usedTableScan());
            assertFalse(rtsp.usedDistinctScan());
        }
        rs.close();
       
        // make sure predicates are null tolerant
       
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.