db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r943088 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java
Date Tue, 11 May 2010 11:26:40 GMT
Author: kahatlen
Date: Tue May 11 11:26:39 2010
New Revision: 943088

URL: http://svn.apache.org/viewvc?rev=943088&view=rev
Log:
DERBY-4650: Predicates in HAVING clause should be pushed down to restricted VTIs

Added a test case that shows that a predicate is not pushed down.

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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java?rev=943088&r1=943087&r2=943088&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/RestrictedVTITest.java
Tue May 11 11:26:39 2010
@@ -627,7 +627,23 @@ public class RestrictedVTITest  extends 
              );
 
     }
-    
+
+    /**
+     * Predicates in HAVING clauses are not (yet) pushed down to the VTI.
+     * Tracked as DERBY-4650.
+     */
+    public void test_08_having() throws Exception
+    {
+        assertPR(
+                getConnection(),
+                "select s_r, count(*) from table(integerList()) t " +
+                "group by s_r having s_r > 1",
+                new String[][] {{"100", "1"}, {"1000", "1"}, {"10000", "1"}},
+                "[S_R, null, null, null]",
+                null // DERBY-4650: should be "\"S_R\" > 1" if pushed down
+                );
+    }
+
     ///////////////////////////////////////////////////////////////////////////////////
     //
     // SQL ROUTINES



Mime
View raw message