public class PrimaryKeyTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
PrimaryKeyTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
protected void |
setUp() |
static junit.framework.Test |
suite() |
void |
testBug5420()
Testing The Bug5420
|
void |
testCatalog()
verify the consistency of the indexes on the system catalogs
|
void |
testConstraintwithNotNull()
Tests that we can combile key constraints with not null.
|
void |
testDeleteFromPrimaryKey()
tests that we can Delete from Primary Key
|
void |
testDerby5111() |
void |
testDuplicateConstraintNames()
Constraint Names must be Unique with in a schema
|
void |
testDuplicatePrimaryKey()
Tests that A table can't contain two primary keys.
|
void |
testExplicitNullabilityOfConstraints()
Tests that primary and Unique key constraint cannot be Explicitely Nullable.
|
void |
testInvalidConstaintDefs()
Tests the Invalid constraint Definations.
|
void |
testInvalidConstraintSchemaNames()
Tests Invalid constraint schema name
|
void |
testKeyConstraintsImpliesNotNull()
Tests that If a column is a part of Primary Key then it cann't contain NULL values.
|
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, tearDown, 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 static junit.framework.Test suite()
protected void setUp() throws java.lang.Exception
setUp
in class junit.framework.TestCase
java.lang.Exception
public void testDuplicatePrimaryKey() throws java.sql.SQLException
java.sql.SQLException
public void testInvalidConstaintDefs() throws java.sql.SQLException
java.sql.SQLException
public void testInvalidConstraintSchemaNames() throws java.sql.SQLException
java.sql.SQLException
public void testDuplicateConstraintNames() throws java.sql.SQLException
java.sql.SQLException
public void testExplicitNullabilityOfConstraints() throws java.sql.SQLException
java.sql.SQLException
public void testKeyConstraintsImpliesNotNull() throws java.sql.SQLException
java.sql.SQLException
public void testConstraintwithNotNull() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteFromPrimaryKey() throws java.sql.SQLException
java.sql.SQLException
public void testCatalog() throws java.sql.SQLException
java.sql.SQLException
public void testBug5420() throws java.sql.SQLException
java.sql.SQLException
public void testDerby5111() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.