public class SpillHashTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private java.sql.PreparedStatement |
distinctStmt |
private static java.lang.String[][] |
initDupVals |
private java.sql.PreparedStatement |
joinStmt |
private static int |
LOTS_OF_ROWS |
private static java.lang.String[] |
prep |
private static java.lang.String[][] |
spillDupVals |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
SpillHashTest(java.lang.String name)
Basic constructor.
|
Modifier and Type | Method and Description |
---|---|
private static java.lang.String |
ca2Val(int col1Val) |
private static java.lang.String |
cb2Val(int col1Val) |
private static void |
checkAllCa1(java.sql.ResultSet rs,
boolean expectDups,
boolean holdOverCommit,
int maxColValue,
java.lang.String[][][] dupVals,
java.lang.String label) |
private static int |
findDupVal(java.sql.ResultSet rs,
int col,
char prefix,
int keyIdx,
java.lang.String[][][] dupVals) |
protected void |
initializeConnection(java.sql.Connection conn)
Sets the auto commit to false.
|
private static void |
insertDups(java.sql.PreparedStatement insA,
java.sql.PreparedStatement insB,
java.lang.String[][] dupVals) |
private static void |
runCursor(java.sql.Connection conn,
int maxColValue,
java.lang.String[][][] dupVals) |
private void |
runDistinct(java.sql.Connection conn,
int maxColValue,
java.lang.String[][][] dupVals) |
private void |
runJoin(java.sql.Connection conn,
int maxColValue,
java.lang.String[][][] dupVals) |
protected void |
setUp() |
static junit.framework.Test |
suite()
Returns the implemented tests.
|
protected void |
tearDown()
Tear down this fixture, sub-classes should call
super.tearDown().
|
void |
testCursorHeavy() |
void |
testCursorLight() |
void |
testDistinctHeavy() |
void |
testDistinctLight() |
void |
testJoinHeavy() |
void |
testJoinLight() |
private static java.lang.String |
trim(java.lang.String str) |
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, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, 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, toString
private static final java.lang.String[] prep
private static final java.lang.String[][] initDupVals
private static final java.lang.String[][] spillDupVals
private static final int LOTS_OF_ROWS
private java.sql.PreparedStatement joinStmt
private java.sql.PreparedStatement distinctStmt
protected void initializeConnection(java.sql.Connection conn) throws java.sql.SQLException
initializeConnection
in class BaseJDBCTestCase
conn
- Connection to be intializedjava.sql.SQLException
- Error setting the initial state.public static junit.framework.Test suite()
Test
with the implemented tests to
run.protected void setUp() throws java.lang.Exception
setUp
in class junit.framework.TestCase
java.lang.Exception
protected void tearDown() throws java.lang.Exception
BaseJDBCTestCase
tearDown
in class BaseJDBCTestCase
java.lang.Exception
public void testJoinLight() throws java.sql.SQLException
java.sql.SQLException
public void testDistinctLight() throws java.sql.SQLException
java.sql.SQLException
public void testCursorLight() throws java.sql.SQLException
java.sql.SQLException
public void testJoinHeavy() throws java.sql.SQLException
java.sql.SQLException
public void testDistinctHeavy() throws java.sql.SQLException
java.sql.SQLException
public void testCursorHeavy() throws java.sql.SQLException
java.sql.SQLException
private static void insertDups(java.sql.PreparedStatement insA, java.sql.PreparedStatement insB, java.lang.String[][] dupVals) throws java.sql.SQLException
java.sql.SQLException
private static java.lang.String ca2Val(int col1Val)
private static java.lang.String cb2Val(int col1Val)
private void runJoin(java.sql.Connection conn, int maxColValue, java.lang.String[][][] dupVals) throws java.sql.SQLException
java.sql.SQLException
private static int findDupVal(java.sql.ResultSet rs, int col, char prefix, int keyIdx, java.lang.String[][][] dupVals) throws java.sql.SQLException
java.sql.SQLException
private static java.lang.String trim(java.lang.String str)
private void runDistinct(java.sql.Connection conn, int maxColValue, java.lang.String[][][] dupVals) throws java.sql.SQLException
java.sql.SQLException
private static void runCursor(java.sql.Connection conn, int maxColValue, java.lang.String[][][] dupVals) throws java.sql.SQLException
java.sql.SQLException
private static void checkAllCa1(java.sql.ResultSet rs, boolean expectDups, boolean holdOverCommit, int maxColValue, java.lang.String[][][] dupVals, java.lang.String label) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.