1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
/*
*
* Derby - Class org.apache.derbyTesting.functionTests.tests.lang.UngroupedAggregatesNegativeTest
*
* 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 Exception {
dropTable("t1");
dropTable("t2");
super.tearDown();
}
/**
* 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();
}
}
|
