public class NullableUniqueConstraintTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
NullableUniqueConstraintTest(java.lang.String name)
Basic constructor.
|
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 |
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.
|
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, 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
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
public NullableUniqueConstraintTest(java.lang.String name)
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 testSingleKeyPartUniqueConstraint() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4677CompressTable() throws java.sql.SQLException
java.sql.SQLException
public void testMultipartKeyUniqueConstraint() throws java.sql.SQLException
java.sql.SQLException
public void testWithDeletedKey() throws java.sql.SQLException
java.sql.SQLException
public void testDistinctQuery() throws java.sql.SQLException
java.sql.SQLException
public void testNullOrdering() throws java.sql.SQLException
java.sql.SQLException
public void testComparisonAcrossPages() throws java.sql.SQLException
java.sql.SQLException
public void testDefferedInsert() throws java.sql.SQLException
java.sql.SQLException
public void testMixedInsertDelete() throws java.sql.SQLException
java.sql.SQLException
public void testDeletedDuplicateHidesDuplicateOnRightSide() throws java.sql.SQLException
java.sql.SQLException
public void testDeletedDuplicateHidesDuplicateOnLeftSide() throws java.sql.SQLException
java.sql.SQLException
public void testInsertDeleteContinuouslySameValue() throws java.sql.SQLException
java.sql.SQLException
public static void main(java.lang.String[] args)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.