public final class AggBuiltinTest extends BaseJDBCTestCase
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 |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
AggBuiltinTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.
|
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) |
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
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, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
private java.sql.Statement st
private java.sql.ResultSet rs
private java.lang.String[] expColNames
private java.lang.String[][] expRS
private final java.lang.String NULLS_ELIMINATED
private java.sql.SQLWarning sqlWarn
private final java.lang.String[][] SINGLE_NULL_ROW
public AggBuiltinTest(java.lang.String name)
name
- test namepublic static junit.framework.Test suite()
public void testBuiltinAggregates() throws java.lang.Exception
java.lang.Exception
private void avg() throws java.sql.SQLException
java.sql.SQLException
private void count() throws java.sql.SQLException
java.sql.SQLException
private void countStar() throws java.sql.SQLException
java.sql.SQLException
private void sum() throws java.sql.SQLException
java.sql.SQLException
private void max() throws java.sql.SQLException
java.sql.SQLException
private void min() throws java.sql.SQLException
java.sql.SQLException
private void var_pop() throws java.sql.SQLException
java.sql.SQLException
private void var_samp() throws java.sql.SQLException
java.sql.SQLException
private void stddev_pop() throws java.sql.SQLException
java.sql.SQLException
private void stddev_samp() throws java.sql.SQLException
java.sql.SQLException
private void x(java.lang.String stmt) throws java.sql.SQLException
java.sql.SQLException
private void q(java.lang.String query) throws java.sql.SQLException
java.sql.SQLException
private void c1() throws java.sql.SQLException
java.sql.SQLException
private void c2() throws java.sql.SQLException
java.sql.SQLException
private void e(java.lang.String expectedState, java.lang.String stmt)
private void ok() throws java.sql.SQLException
java.sql.SQLException
private void ok(java.lang.String[] warnings) throws java.sql.SQLException
java.sql.SQLException
private void ok(java.lang.String warning) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.