db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r1574634 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java
Date Wed, 05 Mar 2014 19:23:15 GMT
Author: myrnavl
Date: Wed Mar  5 19:23:15 2014
New Revision: 1574634

URL: http://svn.apache.org/r1574634
Log:
DERBY-6495; Error in SelectivityTest.testBasic
   add more columns to a number of order by statements to pin the results down.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java?rev=1574634&r1=1574633&r2=1574634&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/SelectivityTest.java
Wed Mar  5 19:23:15 2014
@@ -161,31 +161,31 @@ public class SelectivityTest extends Bas
                 statsrs = s.executeQuery(
                         "select indexname, stats, ncols from showstats " +
                         "where indexname like 'T1%' " +
-                        "order by indexname");
+                        "order by indexname, stats");
                 JDBC.assertFullResultSet(statsrs, new String[][] {
                         {"T1_HUNDRED","numunique= 100 numrows= 4000","1"},
-                        {"T1_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
                         {"T1_TWENTY_HUNDRED","numunique= 20 numrows= 4000","1"},
-                        {"T1_TWO_TWENTY","numunique= 40 numrows= 4000","2"},
-                        {"T1_TWO_TWENTY","numunique= 2 numrows= 4000","1"}});
+                        {"T1_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
+                        {"T1_TWO_TWENTY","numunique= 2 numrows= 4000","1"},
+                        {"T1_TWO_TWENTY","numunique= 40 numrows= 4000","2"}});
                 statsrs = s.executeQuery(
                         "select indexname, stats, ncols from showstats " +
-                        "where indexname like 'T2%' order by indexname");
+                        "where indexname like 'T2%' order by indexname, stats");
                 JDBC.assertFullResultSet(statsrs, new String[][] {
                         {"T2_HUNDRED","numunique= 100 numrows= 4000","1"},
-                        {"T2_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
                         {"T2_TWENTY_HUNDRED","numunique= 20 numrows= 4000","1"},
-                        {"T2_TWO_TWENTY","numunique= 40 numrows= 4000","2"},
-                        {"T2_TWO_TWENTY","numunique= 2 numrows= 4000","1"}});
+                        {"T2_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
+                        {"T2_TWO_TWENTY","numunique= 2 numrows= 4000","1"},
+                        {"T2_TWO_TWENTY","numunique= 40 numrows= 4000","2"}});
                 statsrs = s.executeQuery(
                         "select indexname, stats, ncols from showstats " +
-                        "where indexname like 'T3%' order by indexname");
+                        "where indexname like 'T3%' order by indexname, stats");
                 JDBC.assertFullResultSet(statsrs, new String[][] {
                         {"T3_HUNDRED","numunique= 100 numrows= 4000","1"},
-                        {"T3_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
                         {"T3_TWENTY_HUNDRED","numunique= 20 numrows= 4000","1"},
-                        {"T3_TWO_TWENTY","numunique= 40 numrows= 4000","2"},
-                        {"T3_TWO_TWENTY","numunique= 2 numrows= 4000","1"}});
+                        {"T3_TWENTY_HUNDRED","numunique= 2000 numrows= 4000","2"},
+                        {"T3_TWO_TWENTY","numunique= 2 numrows= 4000","1"},
+                        {"T3_TWO_TWENTY","numunique= 40 numrows= 4000","2"}});
                 
                 s.executeUpdate("create table scratch_table" +
                         "(id int, two int, twenty int, hundred int)");
@@ -1177,7 +1177,7 @@ public class SelectivityTest extends Bas
         
         statsrs = s.executeQuery(
                 "select indexname, stats, ncols from showstats " +
-                "where indexname = 'TBASIC2_CH_DT' order by indexname");
+                "where indexname = 'TBASIC2_CH_DT' order by indexname, stats");
         JDBC.assertFullResultSet(statsrs, new String[][] {
                 {"TBASIC2_CH_DT","numunique= 3 numrows= 7","1"},
                 {"TBASIC2_CH_DT","numunique= 7 numrows= 7","2"}});
@@ -1190,7 +1190,8 @@ public class SelectivityTest extends Bas
         JDBC.assertFullResultSet(statsrs, new String[][] {{"7"}});
         statsrs = s.executeQuery(
                 "select indexname, stats, ncols from showstats " +
-                "where indexname = 'TBASIC2_DT_VC' order by indexname");
+                "where indexname = 'TBASIC2_DT_VC' " +
+                "order by indexname, stats, ncols");
         JDBC.assertFullResultSet(statsrs, new String[][] {
                 {"TBASIC2_DT_VC","numunique= 3 numrows= 7","1"},
                 {"TBASIC2_DT_VC","numunique= 3 numrows= 7","2"}});



Mime
View raw message