org.apache.derbyTesting.functionTests.tests.store

Class AccessTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.store.AccessTest

All Implemented Interfaces:

junit.framework.Test

public final class AccessTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String[]	MODIFIED_DB_PROPS Array with names of database properties that may be modified by the test cases in this class.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	assertStatsOK(java.sql.Statement st, java.lang.String expectedScan, java.lang.String expTableInIndexScan, java.lang.String expIndexInIndexScan, java.lang.String expBits, java.lang.String expNumCols, java.lang.String expDelRowsV, java.lang.String expPages, java.lang.String expRowsQ, java.lang.String expRowsV, java.lang.String expScanType, java.lang.String expStartPosition, java.lang.String expStopPosition, java.lang.String expQualifier, java.lang.String expQualifierInfo)
private void	checkSpaceTable(java.sql.Statement st, java.lang.String expValue)
private void	doQuery(java.sql.Statement st, java.lang.String query, java.lang.String[] expColNames, java.lang.String[][] expRS)
private void	doQuery1(java.sql.Statement st)
private void	doQuery2(java.sql.Statement st)
private void	doQuery3(java.sql.Statement st)
private void	doQuery4(java.sql.Statement st)
private void	doQuery5(java.sql.Statement st)
private void	doQuery6(java.sql.Statement st)
private void	doTestCaseCS4595A(java.sql.Statement st, java.lang.String indexOrConstraint)
private void	doTestCaseCS4595B(java.sql.Statement st, java.lang.String indexOrConstraint)
private void	reclaimDeletedRows2(boolean toCommit)
private void	reclaimTest(java.lang.String createIndex, java.lang.String expectedError)
private void	runQueriesNormal(java.sql.Statement st)
private void	runQueriesWithDeletedRows(java.sql.Statement st)
private void	runQueriesWithIndex(java.sql.Statement st)
private void	runQueriesWithIndexDeletedRows(java.sql.Statement st)
private void	setupForReclaim2(java.sql.Statement st)
static junit.framework.Test	suite()
protected void	tearDown() Tear down the test environment.
void	test_conglomDirectory()
void	testAllUncommittedReclaim()
void	testCaseCS4595A_NonUniqueIndex()
void	testCaseCS4595B_NonUniqueIndex()
void	testCommittedDeletesReclaim()
void	testCostingCoveredQuery()
void	testCS1346()
void	testCS1346b()
void	testCS1552()
void	testCS2241()
void	testCS2778()
void	testCS3149()
void	testCS3368_3370()
void	testCS4595A_PrimaryKey()
void	testCS4595A_UniqueIndex()
void	testCS4595B_PrimaryKey()
void	testCS4595B_UniqueIndex()
void	testCSBug2590()
void	testCSBug735()
void	testKeyTooBigError()
void	testLoadLongColumnsCreateIndex()
void	testPartialRowRTStats()
void	testQualifiers()
void	testQualifierSkipLOLB()
void	testReclaimDeletedRowsDuringSplit()
void	testReclaimDeletedRowsUniqueIndex()
void	testSpaceForUpdate()
void	testUncommittedDeletesNotReclaimed()

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

Methods inherited from class java.lang.Object

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

Field Detail

MODIFIED_DB_PROPS

private static final java.lang.String[] MODIFIED_DB_PROPS

Array with names of database properties that may be modified by the test cases in this class. The properties will be cleared in tearDown().

Constructor Detail

AccessTest

public AccessTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear down the test environment.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testQualifierSkipLOLB

public void testQualifierSkipLOLB()
                           throws java.lang.Exception

Throws:

java.lang.Exception

testCSBug2590

public void testCSBug2590()
                   throws java.lang.Exception

Throws:

java.lang.Exception

testCSBug735

public void testCSBug735()
                  throws java.lang.Exception

Throws:

java.lang.Exception

test_conglomDirectory

public void test_conglomDirectory()
                           throws java.lang.Exception

Throws:

java.lang.Exception

testPartialRowRTStats

public void testPartialRowRTStats()
                           throws java.lang.Exception

Throws:

java.lang.Exception

assertStatsOK

private void assertStatsOK(java.sql.Statement st,
                           java.lang.String expectedScan,
                           java.lang.String expTableInIndexScan,
                           java.lang.String expIndexInIndexScan,
                           java.lang.String expBits,
                           java.lang.String expNumCols,
                           java.lang.String expDelRowsV,
                           java.lang.String expPages,
                           java.lang.String expRowsQ,
                           java.lang.String expRowsV,
                           java.lang.String expScanType,
                           java.lang.String expStartPosition,
                           java.lang.String expStopPosition,
                           java.lang.String expQualifier,
                           java.lang.String expQualifierInfo)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

runQueriesNormal

private void runQueriesNormal(java.sql.Statement st)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

runQueriesWithIndex

private void runQueriesWithIndex(java.sql.Statement st)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

runQueriesWithDeletedRows

private void runQueriesWithDeletedRows(java.sql.Statement st)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

runQueriesWithIndexDeletedRows

private void runQueriesWithIndexDeletedRows(java.sql.Statement st)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery1

private void doQuery1(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery2

private void doQuery2(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery3

private void doQuery3(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery4

private void doQuery4(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery5

private void doQuery5(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery6

private void doQuery6(java.sql.Statement st)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doQuery

private void doQuery(java.sql.Statement st,
                     java.lang.String query,
                     java.lang.String[] expColNames,
                     java.lang.String[][] expRS)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

testCostingCoveredQuery

public void testCostingCoveredQuery()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testKeyTooBigError

public void testKeyTooBigError()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testSpaceForUpdate

public void testSpaceForUpdate()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testLoadLongColumnsCreateIndex

public void testLoadLongColumnsCreateIndex()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testCS1346

public void testCS1346()
                throws java.lang.Exception

Throws:

java.lang.Exception

testCS1346b

public void testCS1346b()
                 throws java.lang.Exception

Throws:

java.lang.Exception

testCS1552

public void testCS1552()
                throws java.lang.Exception

Throws:

java.lang.Exception

testCS2241

public void testCS2241()
                throws java.lang.Exception

Throws:

java.lang.Exception

reclaimTest

private void reclaimTest(java.lang.String createIndex,
                         java.lang.String expectedError)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testReclaimDeletedRowsDuringSplit

public void testReclaimDeletedRowsDuringSplit()
                                       throws java.lang.Exception

Throws:

java.lang.Exception

testReclaimDeletedRowsUniqueIndex

public void testReclaimDeletedRowsUniqueIndex()
                                       throws java.lang.Exception

Throws:

java.lang.Exception

setupForReclaim2

private void setupForReclaim2(java.sql.Statement st)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

reclaimDeletedRows2

private void reclaimDeletedRows2(boolean toCommit)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testUncommittedDeletesNotReclaimed

public void testUncommittedDeletesNotReclaimed()
                                        throws java.lang.Exception

Throws:

java.lang.Exception

testCommittedDeletesReclaim

public void testCommittedDeletesReclaim()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testAllUncommittedReclaim

public void testAllUncommittedReclaim()
                               throws java.lang.Exception

Throws:

java.lang.Exception

testCS2778

public void testCS2778()
                throws java.lang.Exception

Throws:

java.lang.Exception

testCS3149

public void testCS3149()
                throws java.lang.Exception

Throws:

java.lang.Exception

testCS3368_3370

public void testCS3368_3370()
                     throws java.lang.Exception

Throws:

java.lang.Exception

checkSpaceTable

private void checkSpaceTable(java.sql.Statement st,
                             java.lang.String expValue)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

doTestCaseCS4595A

private void doTestCaseCS4595A(java.sql.Statement st,
                               java.lang.String indexOrConstraint)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

doTestCaseCS4595B

private void doTestCaseCS4595B(java.sql.Statement st,
                               java.lang.String indexOrConstraint)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testCS4595A_UniqueIndex

public void testCS4595A_UniqueIndex()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testCS4595B_UniqueIndex

public void testCS4595B_UniqueIndex()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testCS4595A_PrimaryKey

public void testCS4595A_PrimaryKey()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testCS4595B_PrimaryKey

public void testCS4595B_PrimaryKey()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testCaseCS4595A_NonUniqueIndex

public void testCaseCS4595A_NonUniqueIndex()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testCaseCS4595B_NonUniqueIndex

public void testCaseCS4595B_NonUniqueIndex()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testQualifiers

public void testQualifiers()
                    throws java.lang.Exception

Throws:

java.lang.Exception