db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r676771 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ tests/lang/
Date Mon, 14 Jul 2008 23:54:34 GMT
Author: kmarsden
Date: Mon Jul 14 16:54:33 2008
New Revision: 676771

URL: http://svn.apache.org/viewvc?rev=676771&view=rev
Log:
DERBY-3759 Convert "org.apache.derbyTesting.functionTests.tests.lang.ungroupedAggregatesNegative.sql"
to junit.

Contributed by Junjie Peng

Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java
  (with props)
Removed:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ungroupedAggregatesNegative.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ungroupedAggregatesNegative.sql
Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall?rev=676771&r1=676770&r2=676771&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall
Mon Jul 14 16:54:33 2008
@@ -51,5 +51,4 @@
 lang/triggerGeneral.sql
 lang/triggerRecursion.sql
 lang/triggerRefClause.sql
-lang/ungroupedAggregatesNegative.sql
 lang/wisconsin.java

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java?rev=676771&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java
Mon Jul 14 16:54:33 2008
@@ -0,0 +1,105 @@
+/*
+ * 
+ * Derby - Class org.apache.derbyTesting.functionTests.tests.lang.UngroupedAggregatesTest
+ * 
+ * Licensed to the Apache Software Foundation (ASF) under one or more contributor license
+ * agreements. See the NOTICE file distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file to You under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ * 
+ * http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software distributed under
+ * the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the specific language governing
+ * permissions and limitations under the License.
+ * 
+ */
+package org.apache.derbyTesting.functionTests.tests.lang;
+
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import junit.framework.Test;
+
+import org.apache.derbyTesting.junit.BaseJDBCTestCase;
+import org.apache.derbyTesting.junit.TestConfiguration;
+
+/**
+ * Test case for ungroupedAggregatesNegative.sql. 
+ * It provides negative tests for ungrouped aggregates.
+ */
+public class UngroupedAggregatesNegativeTest extends BaseJDBCTestCase {
+
+    public UngroupedAggregatesNegativeTest(String name) {
+        super(name);
+    }
+
+    public static Test suite() {
+        return TestConfiguration.defaultSuite(
+                UngroupedAggregatesNegativeTest.class);
+    }
+
+    public void setUp() throws SQLException {
+        String sql = "create table t1 (c1 int)";
+        Statement st = createStatement();
+        st.executeUpdate(sql);
+
+        sql = "create table t2 (c1 int)";
+        st.executeUpdate(sql);
+
+        sql = "insert into t2 values 1,2,3";
+        assertEquals(3, st.executeUpdate(sql));
+
+        st.close();
+    }
+
+    public void tearDown() throws SQLException {
+        dropTable("t1");
+        dropTable("t2");
+    }
+
+    /**
+     * Mix aggregate and non-aggregate expressions in the select list.
+     */
+    public void testSelect() throws SQLException {
+        String sql = "select c1, max(c1) from t1";
+        assertCompileError("42Y35", sql);
+
+        sql = "select c1 * max(c1) from t1";
+        assertCompileError("42Y35", sql);
+    }
+
+    /**
+     * Aggregate in where clause.
+     */
+    public void testWhereClause() {
+        String sql = "select c1 from t1 where max(c1) = 1";
+        assertCompileError("42903", sql);
+    }
+
+    /**
+     * Aggregate in ON clause of inner join.
+     */
+    public void testOnClause() {
+        String sql = "select * from t1 join t1 " + "as t2 on avg(t2.c1) > 10";
+        assertCompileError("42Z07", sql);
+    }
+
+    /**
+     * Correlated subquery in select list, 
+     * and noncorrelated subquery that returns more than 1 row.
+     * @throws SQLException 
+     */
+    public void testSubquery() throws SQLException {
+        String sql = "select max(c1), (select t2.c1 from t2 "
+                + "where t1.c1 = t2.c1) from t1";
+        assertCompileError("42Y29", sql);
+
+        sql = "select max(c1), (select t2.c1 from t2) from t1";
+        Statement st = createStatement();
+        assertStatementError("21000", st, sql);
+        st.close();
+    }
+}

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/UngroupedAggregatesNegativeTest.java
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java?rev=676771&r1=676770&r2=676771&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java
Mon Jul 14 16:54:33 2008
@@ -135,7 +135,7 @@
         suite.addTest(DeadlockModeTest.suite());
         suite.addTest(AnsiSignaturesTest.suite());
         suite.addTest(PredicatePushdownTest.suite());
-        
+        suite.addTest(UngroupedAggregatesNegativeTest.suite());
         // Add the XML tests, which exist as a separate suite
         // so that users can "run all XML tests" easily.
         suite.addTest(XMLSuite.suite());



Mime
View raw message