org.apache.derbyTesting.functionTests.tests.upgradeTests

Class Changes10_7

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_7

All Implemented Interfaces:

junit.framework.Test

public class Changes10_7
extends UpgradeChange

Upgrade test cases for 10.7. If the old version is 10.7 or later then these tests will not be run.
10.7 Upgrade issues

• BOOLEAN data type support expanded.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	GRANT_REVOKE_WITH_LEGACY_ACCESS
private static java.lang.String	SYNTAX_ERROR
private static java.lang.String	UPGRADE_REQUIRED

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_7(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private void	checkWarning(java.sql.Statement st, java.lang.String expectedWarning)
private void	createTableAndTrigger(java.lang.String tableName, java.lang.String triggerName, boolean usesReferencingClause)
private java.util.Set	getSupportedTypes() Get the names of all supported types, as reported by DatabaseMetaData.getTypeInfo().
private void	incorrectBehaviorForDropColumn(java.lang.String tableName, java.lang.String triggerName, java.lang.String restrictOrCascade)
static junit.framework.Test	suite(int phase) Return the suite of tests to test the changes made in 10.7.
void	testAlterTableDropColumnAndTriggerAction() This test creates 2 kinds of triggers in old release for each of the three phase of upgrade.
void	testBoolean() Make sure that that database is at level 10.7 in order to enjoy extended support for the BOOLEAN datatype.
void	testExternalSecuritySpecification() Make sure that that database is at level 10.7 in order to enjoy routines with specified EXTERNAL SECURITY INVOKER or DEFINER.
void	testTriggers() Make sure that DERBY-1482 changes do not break backward compatibility

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, 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, tearDown, 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, setUp, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

SYNTAX_ERROR

private static final java.lang.String SYNTAX_ERROR

See Also:

Constant Field Values

UPGRADE_REQUIRED

private static final java.lang.String UPGRADE_REQUIRED

See Also:

Constant Field Values

GRANT_REVOKE_WITH_LEGACY_ACCESS

private static final java.lang.String GRANT_REVOKE_WITH_LEGACY_ACCESS

See Also:

Constant Field Values

Constructor Detail

Changes10_7

public Changes10_7(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.7.

Parameters:

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

Returns:

the test suite created.

testBoolean

public void testBoolean()
                 throws java.sql.SQLException

Make sure that that database is at level 10.7 in order to enjoy extended support for the BOOLEAN datatype.

Throws:

java.sql.SQLException

getSupportedTypes

private java.util.Set getSupportedTypes()
                                 throws java.sql.SQLException

Get the names of all supported types, as reported by DatabaseMetaData.getTypeInfo().

Returns:

a set with the names of all supported types in the loaded version of Derby

Throws:

java.sql.SQLException

testAlterTableDropColumnAndTriggerAction

public void testAlterTableDropColumnAndTriggerAction()
                                              throws java.lang.Exception

This test creates 2 kinds of triggers in old release for each of the three phase of upgrade. The triggers are of following 2 types 1)trigger action using columns available through the REFERENCING clause. 2)trigger action using columns without the REFERENCING clause. For both kinds of triggers, there is test case which drops the column being used in the trigger action column. In all three modes of upgrade, soft upgrade, post soft upgrade, and hard upgrade, ALTER TABLE DROP COLUMN will detect the trigger dependency.

Throws:

java.lang.Exception

createTableAndTrigger

private void createTableAndTrigger(java.lang.String tableName,
                                   java.lang.String triggerName,
                                   boolean usesReferencingClause)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

incorrectBehaviorForDropColumn

private void incorrectBehaviorForDropColumn(java.lang.String tableName,
                                            java.lang.String triggerName,
                                            java.lang.String restrictOrCascade)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

checkWarning

private void checkWarning(java.sql.Statement st,
                          java.lang.String expectedWarning)
                   throws java.lang.Exception

Throws:

java.lang.Exception

testTriggers

public void testTriggers()
                  throws java.sql.SQLException

Make sure that DERBY-1482 changes do not break backward compatibility

Throws:

java.sql.SQLException

testExternalSecuritySpecification

public void testExternalSecuritySpecification()
                                       throws java.sql.SQLException

Make sure that that database is at level 10.7 in order to enjoy routines with specified EXTERNAL SECURITY INVOKER or DEFINER.

Throws:

java.sql.SQLException