org.apache.derbyTesting.functionTests.tests.lang

Class NullableUniqueConstraintTest

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

All Implemented Interfaces:

junit.framework.Test

public class NullableUniqueConstraintTest
extends BaseJDBCTestCase

Test unique constraint

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static java.lang.String	expImpDataFile
(package private) static boolean	exportFilesCreated
private static java.lang.String	LANG_DUPLICATE_KEY_CONSTRAINT

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
NullableUniqueConstraintTest(java.lang.String name) Basic constructor.

Method Summary

Modifier and Type	Method and Description
static void	main(java.lang.String[] args)
protected void	setUp() Create table for test cases to use.
static junit.framework.Test	suite() Returns the implemented tests.
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testComparisonAcrossPages() Tries to forces internal routibe to travel across pages to check for duplicates.
void	testDefferedInsert() Checks is insert for updates uses deffered inserts or not.
void	testDeletedDuplicateHidesDuplicateOnLeftSide() Test that a deleted duplicate value on the left side of the slot into which a new value is inserted does not hide a non-deleted duplicate two slots to the left.
void	testDeletedDuplicateHidesDuplicateOnRightSide() Test that a deleted duplicate value on the right side of the slot into which a new value is inserted does not hide a non-deleted duplicate two slots to the right.
void	testDerby4677CompressTable() Compress table should recreate the indexes correctly rather than ignoring the unique nullable property of the index
void	testDerby6374()
void	testDistinctQuery()
void	testInsertDeleteContinuouslySameValue() Test that we can insert and delete the same value multiple times in a nullable unique index.
void	testMixedInsertDelete() Test that repeatedly performing multi-row inserts and deletes spanning multiple pages works correctly with nullable unique constraint.
void	testMultipartKeyUniqueConstraint() Basic test of Unique Constraint using multipart part key.
void	testNullOrdering() Test null ordering of the key in order by query.
void	testSingleKeyPartUniqueConstraint() Basic test of Unique Constraint using single part key.
void	testWithDeletedKey() Inserts a duplicate key of a deleted key within same transaction.

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

LANG_DUPLICATE_KEY_CONSTRAINT

private static final java.lang.String LANG_DUPLICATE_KEY_CONSTRAINT

See Also:

Constant Field Values

expImpDataFile

static java.lang.String expImpDataFile

exportFilesCreated

static boolean exportFilesCreated

Constructor Detail

NullableUniqueConstraintTest

public NullableUniqueConstraintTest(java.lang.String name)

Basic constructor.

Method Detail

suite

public static junit.framework.Test suite()

Returns the implemented tests.

Returns:

An instance of Test with the implemented tests to run.

setUp

protected void setUp()
              throws java.lang.Exception

Create table for test cases to use.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

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

testSingleKeyPartUniqueConstraint

public void testSingleKeyPartUniqueConstraint()
                                       throws java.sql.SQLException

Basic test of Unique Constraint using single part key.

Throws:

java.sql.SQLException

testDerby4677CompressTable

public void testDerby4677CompressTable()
                                throws java.sql.SQLException

Compress table should recreate the indexes correctly rather than ignoring the unique nullable property of the index

Throws:

java.sql.SQLException

testMultipartKeyUniqueConstraint

public void testMultipartKeyUniqueConstraint()
                                      throws java.sql.SQLException

Basic test of Unique Constraint using multipart part key.

Throws:

java.sql.SQLException

testWithDeletedKey

public void testWithDeletedKey()
                        throws java.sql.SQLException

Inserts a duplicate key of a deleted key within same transaction.

Throws:

java.sql.SQLException

testDistinctQuery

public void testDistinctQuery()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testNullOrdering

public void testNullOrdering()
                      throws java.sql.SQLException

Test null ordering of the key in order by query.

Throws:

java.sql.SQLException

testComparisonAcrossPages

public void testComparisonAcrossPages()
                               throws java.sql.SQLException

Tries to forces internal routibe to travel across pages to check for duplicates. It first inserts large number of records assuming they occupy multiple pages in index and then tries to insert duplicates of each of them. Rrecords at the page boundry will require duplucate checking routine to check more than one page to look for locate. If that routine is not working properly duplucate will be inserted in tree.

Throws:

java.sql.SQLException

testDefferedInsert

public void testDefferedInsert()
                        throws java.sql.SQLException

Checks is insert for updates uses deffered inserts or not. It inserts two part keys in the form of part1 part2 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 3 3 and then tries to update all the records so that the values part1 and part2 are interchanged. Internally updates are treated as delete and insert and unless inserts are deffered till all deletes are over, there will be unique constraint violation.

Throws:

java.sql.SQLException

testMixedInsertDelete

public void testMixedInsertDelete()
                           throws java.sql.SQLException

Test that repeatedly performing multi-row inserts and deletes spanning multiple pages works correctly with nullable unique constraint. This used to cause ERROR XSDA1: An attempt was made to access an out of range slot on a page (DERBY-4027).

Throws:

java.sql.SQLException

testDeletedDuplicateHidesDuplicateOnRightSide

public void testDeletedDuplicateHidesDuplicateOnRightSide()
                                                   throws java.sql.SQLException

Test that a deleted duplicate value on the right side of the slot into which a new value is inserted does not hide a non-deleted duplicate two slots to the right. DERBY-4028

Throws:

java.sql.SQLException

testDeletedDuplicateHidesDuplicateOnLeftSide

public void testDeletedDuplicateHidesDuplicateOnLeftSide()
                                                  throws java.sql.SQLException

Test that a deleted duplicate value on the left side of the slot into which a new value is inserted does not hide a non-deleted duplicate two slots to the left. DERBY-4028

Throws:

java.sql.SQLException

testInsertDeleteContinuouslySameValue

public void testInsertDeleteContinuouslySameValue()
                                           throws java.sql.SQLException

Test that we can insert and delete the same value multiple times in a nullable unique index. This used to cause a livelock before DERBY-4081 because the duplicate check on insert sometimes didn't release all latches.

Throws:

java.sql.SQLException

testDerby6374

public void testDerby6374()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)