Examples of usedDistinctScan()

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

744
745
746
747
748
749
750
751
752
753
754
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());

    assertRowCount(9, s.executeQuery("select distinct a.c1, a.c3, a.c2 from two a, one b where a.c1 = b.c1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());

    assertRowCount(9, s.executeQuery("select distinct a.c1, a.c3, a.c2 from two a, two b where a.c1 = b.c1 and b.c3 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

749
750
751
752
753
754
755
756
757
758
759
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());

    assertRowCount(9, s.executeQuery("select distinct a.c1, a.c3, a.c2 from two a, two b where a.c1 = b.c1 and b.c3 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());

    //join between two tables using both columns of unique key
    assertRowCount(3, s.executeQuery("select distinct a.c1 from two a, four b where a.c1 = b.c1 and a.c3 = b.c3 and b.c3 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here

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

755
756
757
758
759
760
761
762
763
764
765
    assertFalse(rtsp.eliminatedDuplicates());

    //join between two tables using both columns of unique key
    assertRowCount(3, s.executeQuery("select distinct a.c1 from two a, four b where a.c1 = b.c1 and a.c3 = b.c3 and b.c3 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());
 
    s.execute("drop table temp_result");
    s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0)");
    s.close();
View Full Code Here

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

780
781
782
783
784
785
786
787
788
789
790
    s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
     
    // first column of an index
    assertRowCount(4, s.executeQuery("select distinct c1 from t1 where 1=1"));
    RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    // equality predicate on preceding key columns
    assertRowCount(1, s.executeQuery("select distinct c2 from t1 where c1 = 1 and c3 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here

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

786
787
788
789
790
791
792
793
794
795
796
    assertTrue(rtsp.eliminatedDuplicates());

    // equality predicate on preceding key columns
    assertRowCount(1, s.executeQuery("select distinct c2 from t1 where c1 = 1 and c3 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());
   
    // equality predicate on all key columns, non unique
    assertRowCount(1, s.executeQuery("select distinct c3 from t1 where c1 = 1 and c2 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here

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

792
793
794
795
796
797
798
799
800
801
802
    assertTrue(rtsp.eliminatedDuplicates());
   
    // equality predicate on all key columns, non unique
    assertRowCount(1, s.executeQuery("select distinct c3 from t1 where c1 = 1 and c2 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());
   
    // equality predicate on all key columns, non unique
    assertRowCount(1, s.executeQuery("select distinct c3 from t2 where c1 = 1 and c2 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here

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

798
799
800
801
802
803
804
805
806
807
808
    assertTrue(rtsp.eliminatedDuplicates());
   
    // equality predicate on all key columns, non unique
    assertRowCount(1, s.executeQuery("select distinct c3 from t2 where c1 = 1 and c2 = '1'"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertFalse(rtsp.eliminatedDuplicates());
   
    // different orderings
    assertRowCount(6, s.executeQuery("select distinct c2, c1 from t1 where 1=1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
View Full Code Here

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

804
805
806
807
808
809
810
811
812
813
814
    assertFalse(rtsp.eliminatedDuplicates());
   
    // different orderings
    assertRowCount(6, s.executeQuery("select distinct c2, c1 from t1 where 1=1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    assertRowCount(2, s.executeQuery("select distinct c2 from t1 where c1 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

809
810
811
812
813
814
815
816
817
818
819
    assertFalse(rtsp.usedDistinctScan());
    assertTrue(rtsp.eliminatedDuplicates());

    assertRowCount(2, s.executeQuery("select distinct c2 from t1 where c1 = 1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    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());
View Full Code Here

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
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.