org.apache.derbyTesting.functionTests.tests.lang

Class AggBuiltinTest

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.AggBuiltinTest

All Implemented Interfaces:

junit.framework.Test

public final class AggBuiltinTest
extends BaseJDBCTestCase

Test aggregate built-ins

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String[]	expColNames
private java.lang.String[][]	expRS
private java.lang.String	NULLS_ELIMINATED
private java.sql.ResultSet	rs
private java.lang.String[][]	SINGLE_NULL_ROW
private java.sql.SQLWarning	sqlWarn
private java.sql.Statement	st

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
AggBuiltinTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
private void	avg()
private void	c1()
private void	c2()
private void	count()
private void	countStar()
private void	e(java.lang.String expectedState, java.lang.String stmt)
private void	max()
private void	min()
private void	ok()
private void	ok(java.lang.String warning)
private void	ok(java.lang.String[] warnings)
private void	q(java.lang.String query)
private void	stddev_pop()
private void	stddev_samp()
static junit.framework.Test	suite()
private void	sum()
void	testBuiltinAggregates()
private void	var_pop()
private void	var_samp()
private void	x(java.lang.String stmt)

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

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

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

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

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, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

st

private java.sql.Statement st

rs

private java.sql.ResultSet rs

expColNames

private java.lang.String[] expColNames

expRS

private java.lang.String[][] expRS

NULLS_ELIMINATED

private final java.lang.String NULLS_ELIMINATED

See Also:

Constant Field Values

sqlWarn

private java.sql.SQLWarning sqlWarn

SINGLE_NULL_ROW

private final java.lang.String[][] SINGLE_NULL_ROW

Constructor Detail

AggBuiltinTest

public AggBuiltinTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Parameters:

name - test name

Method Detail

suite

public static junit.framework.Test suite()

testBuiltinAggregates

public void testBuiltinAggregates()
                           throws java.lang.Exception

Throws:

java.lang.Exception

avg

private void avg()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

count

private void count()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

countStar

private void countStar()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

sum

private void sum()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

max

private void max()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

min

private void min()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

var_pop

private void var_pop()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

var_samp

private void var_samp()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

stddev_pop

private void stddev_pop()
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

stddev_samp

private void stddev_samp()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

x

private void x(java.lang.String stmt)
        throws java.sql.SQLException

Throws:

java.sql.SQLException

q

private void q(java.lang.String query)
        throws java.sql.SQLException

Throws:

java.sql.SQLException

c1

private void c1()
         throws java.sql.SQLException

Throws:

java.sql.SQLException

c2

private void c2()
         throws java.sql.SQLException

Throws:

java.sql.SQLException

e

private void e(java.lang.String expectedState,
               java.lang.String stmt)

ok

private void ok()
         throws java.sql.SQLException

Throws:

java.sql.SQLException

ok

private void ok(java.lang.String[] warnings)
         throws java.sql.SQLException

Throws:

java.sql.SQLException

ok

private void ok(java.lang.String warning)
         throws java.sql.SQLException

Throws:

java.sql.SQLException