org.apache.derbyTesting.functionTests.tests.lang

Class UngroupedAggregatesNegativeTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.UngroupedAggregatesNegativeTest

All Implemented Interfaces:

junit.framework.Test

public class UngroupedAggregatesNegativeTest
extends BaseJDBCTestCase

Test case for ungroupedAggregatesNegative.sql. It provides negative tests for ungrouped aggregates.

Field Summary

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
UngroupedAggregatesNegativeTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
void	setUp()
static junit.framework.Test	suite()
void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testOnClause() Aggregate in ON clause of inner join.
void	testSelect() Mix aggregate and non-aggregate expressions in the select list.
void	testSubquery() Correlated subquery in select list, and noncorrelated subquery that returns more than 1 row.
void	testUDAWithoutGenerics() Test that we get a reasonable error when trying to invoke a user-defined aggregate on a vm which doesn't support generics.
void	testWhereClause() Aggregate in where clause.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

UngroupedAggregatesNegativeTest

public UngroupedAggregatesNegativeTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

public void setUp()
           throws java.sql.SQLException

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

public void tearDown()
              throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testSelect

public void testSelect()
                throws java.sql.SQLException

Mix aggregate and non-aggregate expressions in the select list.

Throws:

java.sql.SQLException

testWhereClause

public void testWhereClause()

Aggregate in where clause.

testOnClause

public void testOnClause()

Aggregate in ON clause of inner join.

testSubquery

public void testSubquery()
                  throws java.sql.SQLException

Correlated subquery in select list, and noncorrelated subquery that returns more than 1 row.

Throws:

java.sql.SQLException

testUDAWithoutGenerics

public void testUDAWithoutGenerics()
                            throws java.lang.Exception

Test that we get a reasonable error when trying to invoke a user-defined aggregate on a vm which doesn't support generics.

Throws:

java.lang.Exception