You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2008/07/15 01:54:34 UTC
svn commit: r676771 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/ suites/ tests/lang/
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());