Examples of eliminatedDuplicates()

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

781
782
783
784
785
786
787
788
789
790
791
     
    // 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);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

787
788
789
790
791
792
793
794
795
796
797
    // 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);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

793
794
795
796
797
798
799
800
801
802
803
   
    // 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);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

799
800
801
802
803
804
805
806
807
808
809
   
    // 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);
    assertFalse(rtsp.usedDistinctScan());
View Full Code Here

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

805
806
807
808
809
810
811
812
813
814
815
   
    // 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());
    assertTrue(rtsp.eliminatedDuplicates());
View Full Code Here

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

810
811
812
813
814
815
816
817
818
819
820
    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());
    assertTrue(rtsp.eliminatedDuplicates());
View Full Code Here

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

815
816
817
818
819
820
821
822
823
824
825
    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());
    assertTrue(rtsp.eliminatedDuplicates());
View Full Code Here

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

820
821
822
823
824
825
826
827
828
829
830
    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
    // implementation), but adding an order by to the query may
View Full Code Here

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

840
841
842
843
844
845
846
847
848
849
850
   
    // 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");
    s.execute("drop table t2");
View Full Code Here

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

653
654
655
656
657
658
659
660
661
662
663
   
    // more than one table in the select list
    // Following runtime statistics output should have Eliminate duplicates = true
    assertRowCount(3, s.executeQuery("select distinct a.c1, b.c1 from one a, two b where a.c1 = b.c1 and b.c2 =1"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.eliminatedDuplicates()); 
   
    // cross product join
    assertRowCount(8, s.executeQuery("select distinct a.c1 from one a, two b"));
    rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.eliminatedDuplicates()); 
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.