org.apache.derbyTesting.functionTests.tests.upgradeTests

Class Changes10_12

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeChange

org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_12

All Implemented Interfaces:

junit.framework.Test

public class Changes10_12
extends UpgradeChange

Upgrade test cases for 10.12.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	LANG_AI_CANNOT_MODIFY_AI
private static java.lang.String	LANG_NULL_INTO_NON_NULL

Fields inherited from class org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeChange

oldVersion, PH_CREATE, PH_HARD_UPGRADE, PH_POST_HARD_UPGRADE, PH_POST_SOFT_UPGRADE, PH_SOFT_UPGRADE, phase, PHASES, SQLSTATE_NEED_UPGRADE

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite(int phase) Return the suite of tests to test the changes made in 10.12.
void	testAlterTableAddIdentity() Test the addition of support for adding identity columns with an ALTER TABLE statement.
void	testDerby6414UpdateIdentityColumn() DERBY-6414(Incorrect handling when using an UPDATE to SET an identity column to DEFAULT) Starting Derby 10.12, we support updating an identity column using the keyword DEFAULT on 10.11 and higher dbs.

Methods inherited from class org.apache.derbyTesting.functionTests.tests.upgradeTests.UpgradeChange

getOldFixPack, getOldMajor, getOldMinor, getOldPoint, getOldVersion, getOldVersionString, getPhase, getPhaseString, oldAtLeast, oldIs, oldIs, oldLessThan

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

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

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

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

LANG_AI_CANNOT_MODIFY_AI

private static final java.lang.String LANG_AI_CANNOT_MODIFY_AI

See Also:

Constant Field Values

LANG_NULL_INTO_NON_NULL

private static final java.lang.String LANG_NULL_INTO_NON_NULL

See Also:

Constant Field Values

Constructor Detail

Changes10_12

public Changes10_12(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite(int phase)

Return the suite of tests to test the changes made in 10.12.

Parameters:

phase - an integer that indicates the current phase in the upgrade test.

Returns:

the test suite created.

testDerby6414UpdateIdentityColumn

public void testDerby6414UpdateIdentityColumn()
                                       throws java.sql.SQLException

DERBY-6414(Incorrect handling when using an UPDATE to SET an identity column to DEFAULT) Starting Derby 10.12, we support updating an identity column using the keyword DEFAULT on 10.11 and higher dbs. A 10.11 database in soft upgrade mode can use this feature to update identity columns. Database versions earlier than that will not be able to use this feature. The reason for restricting the functionality to 10.11 and higher dbs is that starting 10.11, we started using sequence generator to create unique values for identity columns. Prior to that, we had really old code to generate unique values. In order to keep the code clean in 10.12, DERBY-6414 is fixed only for identity columns using sequence generator to create the new ids.

Throws:

java.sql.SQLException

testAlterTableAddIdentity

public void testAlterTableAddIdentity()
                               throws java.sql.SQLException

Test the addition of support for adding identity columns with an ALTER TABLE statement. DERBY-3888.

Throws:

java.sql.SQLException