org.apache.derbyTesting.functionTests.tests.store

Class RowLockBasicTest

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

All Implemented Interfaces:

junit.framework.Test

public class RowLockBasicTest
extends BaseJDBCTestCase

Very basic single user testing of row locking, verify that the right locks are obtained for simple operations. This test only looks at table and row logical locks, it does not verify physical latches or lock ordering. The basic methodology is: start transaction simple operation print lock table which should match the master end transation

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	createLockTableQueryEntries(java.sql.Statement s)
private void	createTableAandUniqueIndex(java.sql.Statement st)
protected void	setUp()
static junit.framework.Test	suite()
void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testCreateIndexDoesTableLevelLocking() Verify that create index does table level locking.
void	testFullCoveredIndexScan() Do full covered index scan.
void	testInsertIntoBtree()
void	testInsertIntoHeap()
void	testInsertOnNewPage() Cause an insert on a new page that inserts into the 1st slot on the btree page.
void	testSetOfRangeScanFor0RowReturn() Do set of range scans that all return 0 row from covered index.
void	testSetOfRangeScanFor1RowReturn() Do set of range scans that all return 1 row from covered index.
void	testSingleProbeIntoFirstKey() Do single probe into covered index (first key in table).
void	testSingleProbeIntoLastKey() Do single probe into covered index (last key in table).

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

Constructor Detail

RowLockBasicTest

public RowLockBasicTest(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

createLockTableQueryEntries

private void createLockTableQueryEntries(java.sql.Statement s)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

tearDown

public 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

testInsertIntoHeap

public void testInsertIntoHeap()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testInsertIntoBtree

public void testInsertIntoBtree()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testInsertOnNewPage

public void testInsertOnNewPage()
                         throws java.sql.SQLException

Cause an insert on a new page that inserts into the 1st slot on the btree page. btree just before commit: leftmost leaf: (1,6), (1,7) next leaf: (2,7), (2,6)

Throws:

java.sql.SQLException

testFullCoveredIndexScan

public void testFullCoveredIndexScan()
                              throws java.sql.SQLException

Do full covered index scan.

Throws:

java.sql.SQLException

createTableAandUniqueIndex

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

Throws:

java.sql.SQLException

testSingleProbeIntoFirstKey

public void testSingleProbeIntoFirstKey()
                                 throws java.sql.SQLException

Do single probe into covered index (first key in table).

Throws:

java.sql.SQLException

testSingleProbeIntoLastKey

public void testSingleProbeIntoLastKey()
                                throws java.sql.SQLException

Do single probe into covered index (last key in table).

Throws:

java.sql.SQLException

testSetOfRangeScanFor1RowReturn

public void testSetOfRangeScanFor1RowReturn()
                                     throws java.sql.SQLException

Do set of range scans that all return 1 row from covered index.

Throws:

java.sql.SQLException

testSetOfRangeScanFor0RowReturn

public void testSetOfRangeScanFor0RowReturn()
                                     throws java.sql.SQLException

Do set of range scans that all return 0 row from covered index.

Throws:

java.sql.SQLException

testCreateIndexDoesTableLevelLocking

public void testCreateIndexDoesTableLevelLocking()
                                          throws java.sql.SQLException

Verify that create index does table level locking.

Throws:

java.sql.SQLException