public class OLAPTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
LANG_COLUMN_NOT_FOUND |
private static java.lang.String |
LANG_SYNTAX_ERROR |
private static java.lang.String |
LANG_WINDOW_FUNCTION_CONTEXT_ERROR |
private static java.lang.String |
NOT_IMPLEMENTED |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
OLAPTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
private void |
dumpIt(java.sql.Statement s,
int cols,
java.lang.String sql) |
private java.lang.String |
makeString(int len) |
static junit.framework.Test |
makeSuite() |
static junit.framework.Test |
suite() |
void |
testBasicOperations()
Main test body
|
void |
testGroupByRollup()
Basic test of GROUP BY ROLLUP capability.
|
void |
testGroupByWithAndWithoutRollup() |
void |
testMetaData() |
void |
testRollupColumnNullability()
Verify that non-aggregate columns are returned as NULLABLE if ROLLUP.
|
void |
testRollupEmptyTables()
Verify the behavior of GROUP BY ROLLUP for empty result sets.
|
void |
testRollupNullabilityCasts()
A ROLLUP case suggested by Dag in 1-sep-2009 comment on DERBY-3002
|
void |
testRollupOfCoveringIndex()
Verify the behavior of GROUP BY ROLLUP when it can use a covering index.
|
void |
testRollupReservedWord()
Verify that ROLLUP can still be used as the name of a column or table.
|
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 static final java.lang.String LANG_WINDOW_FUNCTION_CONTEXT_ERROR
private static final java.lang.String NOT_IMPLEMENTED
private static final java.lang.String LANG_SYNTAX_ERROR
private static final java.lang.String LANG_COLUMN_NOT_FOUND
public static junit.framework.Test makeSuite()
public static junit.framework.Test suite()
public void testBasicOperations() throws java.sql.SQLException
java.sql.SQLException
public void testMetaData() throws java.sql.SQLException
java.sql.SQLException
private java.lang.String makeString(int len)
public void testGroupByRollup() throws java.sql.SQLException
java.sql.SQLException
public void testRollupReservedWord() throws java.sql.SQLException
java.sql.SQLException
public void testRollupColumnNullability() throws java.sql.SQLException
java.sql.SQLException
public void testRollupEmptyTables() throws java.sql.SQLException
java.sql.SQLException
public void testRollupNullabilityCasts() throws java.sql.SQLException
java.sql.SQLException
public void testRollupOfCoveringIndex() throws java.sql.SQLException
java.sql.SQLException
private void dumpIt(java.sql.Statement s, int cols, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public void testGroupByWithAndWithoutRollup() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.