org.apache.derbyTesting.functionTests.tests.lang

Class largeCodeGen

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

All Implemented Interfaces:

junit.framework.Test

public class largeCodeGen
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static boolean	TEST_QUERY_EXECUTION

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private static void	checkRowData(java.sql.ResultSet rs)
private boolean	checkT0Query(java.lang.String testName, java.lang.StringBuffer sqlBuffer, int numParams, int paramValue) Prepares and executes query against table t0 with n parameters The assumption is that the query will always return our one row of data inserted into the t0 table.
private boolean	inClause(int numParams) Test in clause with many parameters
private boolean	insertValues(int rowCount) Create a large insert statement with rowCount rows all with constants.
private boolean	largeUnionSelect(java.lang.String viewName, int numUnions)
private boolean	logicalOperators(int numOperands) Tests numParam parameter markers in a where clause
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testInClause()
void	testInsertValues() Test an INSERT statement with a large number of rows in the VALUES clause.
void	testLogicalOperators() Test many logical operators in the where clause.
void	testUnions()

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

Field Detail

TEST_QUERY_EXECUTION

private static boolean TEST_QUERY_EXECUTION

Constructor Detail

largeCodeGen

public largeCodeGen(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.sql.SQLException

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected 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

checkT0Query

private boolean checkT0Query(java.lang.String testName,
                             java.lang.StringBuffer sqlBuffer,
                             int numParams,
                             int paramValue)

Prepares and executes query against table t0 with n parameters The assumption is that the query will always return our one row of data inserted into the t0 table.

Parameters:

testName -

sqlBuffer - - StringBuffer with SQL Text

numParams - - Number of parameters

paramValue - - Parameter value

Returns:

true if the check fails

testLogicalOperators

public void testLogicalOperators()
                          throws java.sql.SQLException

Test many logical operators in the where clause.

Throws:

java.sql.SQLException

logicalOperators

private boolean logicalOperators(int numOperands)
                          throws java.sql.SQLException

Tests numParam parameter markers in a where clause

Parameters:

numOperands -

Throws:

java.sql.SQLException

testInClause

public void testInClause()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

inClause

private boolean inClause(int numParams)
                  throws java.sql.SQLException

Test in clause with many parameters

Parameters:

numParams - Number of parameters to test

Returns:

true if the test fails

Throws:

java.sql.SQLException

testUnions

public void testUnions()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

largeUnionSelect

private boolean largeUnionSelect(java.lang.String viewName,
                                 int numUnions)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

checkRowData

private static void checkRowData(java.sql.ResultSet rs)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testInsertValues

public void testInsertValues()
                      throws java.sql.SQLException

Test an INSERT statement with a large number of rows in the VALUES clause. Reported as DERBY-1714.

Throws:

java.sql.SQLException

insertValues

private boolean insertValues(int rowCount)
                      throws java.sql.SQLException

Create a large insert statement with rowCount rows all with constants. Prepare and execute it and then rollback to leave the table unchanged.

Parameters:

rowCount -

Returns:

false if rollback succeeds, otherwise true

Throws:

java.sql.SQLException