org.apache.derbyTesting.functionTests.tests.upgradeTests

Class Changes10_10

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_10

All Implemented Interfaces:

junit.framework.Test

public class Changes10_10
extends UpgradeChange

Upgrade test cases for 10.10.

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static double[]	beyondDB2Double
(package private) static float[]	beyondDB2Real
private static java.lang.String	DB_README_FILE_NAME The readme file cautioning users against touching the files in the database directory
private static java.lang.String	HARD_UPGRADE_REQUIRED
private static java.lang.String	NEEDS_JAVA_STYLE
private static java.lang.String	SYNTAX_ERROR

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

Method Summary

Modifier and Type	Method and Description
private void	assertSetError(java.sql.PreparedStatement ps, double dv, boolean defer)
private void	assertSetError(java.sql.PreparedStatement ps, float fv, boolean defer)
private void	assertUpdateError(java.sql.PreparedStatement ps, double fv, boolean defer)
private void	assertUpdateError(java.sql.PreparedStatement ps, float fv, boolean defer)
private void	lookForReadmeFile(java.lang.String path, boolean fileShouldExist) For pre-10.10 database, fileShouldExist will be false.
static junit.framework.Test	suite(int phase) Return the suite of tests to test the changes made in 10.10.
void	testFloatLimits() Verify upgrade behavior DERBY-3398: removing DB2 float limits
void	testProcsNewTo10_10() Make sure that the following procedure(s) which are new to 10.10 are only available after hard-upgrade 1)invalidate stored statements SYCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS
void	testReadMeFiles() DERBY-5996(Create readme files (cautioning users against modifying database files) at database hard upgrade time) Simple test to make sure readme files are getting created
void	testUDAs() Verify upgrade behavior for user-defined aggregates.
void	testVarargss() Verify upgrade behavior for vararg routines.
private void	verifyDB2Behavior(java.sql.PreparedStatement psSelect, java.sql.PreparedStatement psInsertReal, java.sql.PreparedStatement psInsertDouble, boolean defer) Check that the old DB2 limits are (still) enforced.
private void	vetProcs(java.sql.Statement s, java.lang.String procCall, boolean shouldExist, java.lang.String sqlState)

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

HARD_UPGRADE_REQUIRED

private static final java.lang.String HARD_UPGRADE_REQUIRED

See Also:

Constant Field Values

NEEDS_JAVA_STYLE

private static final java.lang.String NEEDS_JAVA_STYLE

See Also:

Constant Field Values

DB_README_FILE_NAME

private static final java.lang.String DB_README_FILE_NAME

The readme file cautioning users against touching the files in the database directory

See Also:

Constant Field Values

beyondDB2Real

static final float[] beyondDB2Real

beyondDB2Double

static final double[] beyondDB2Double

Constructor Detail

Changes10_10

public Changes10_10(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.10.

Parameters:

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

Returns:

the test suite created.

testProcsNewTo10_10

public void testProcsNewTo10_10()
                         throws java.lang.Exception

Make sure that the following procedure(s) which are new to 10.10 are only available after hard-upgrade 1)invalidate stored statements SYCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS

Throws:

java.lang.Exception

vetProcs

private void vetProcs(java.sql.Statement s,
                      java.lang.String procCall,
                      boolean shouldExist,
                      java.lang.String sqlState)
               throws java.lang.Exception

Throws:

java.lang.Exception

testUDAs

public void testUDAs()
              throws java.lang.Exception

Verify upgrade behavior for user-defined aggregates.

Throws:

java.lang.Exception

testVarargss

public void testVarargss()
                  throws java.lang.Exception

Verify upgrade behavior for vararg routines.

Throws:

java.lang.Exception

testReadMeFiles

public void testReadMeFiles()
                     throws java.sql.SQLException,
                            java.io.IOException

DERBY-5996(Create readme files (cautioning users against modifying database files) at database hard upgrade time) Simple test to make sure readme files are getting created

Throws:

java.sql.SQLException

java.io.IOException

lookForReadmeFile

private void lookForReadmeFile(java.lang.String path,
                               boolean fileShouldExist)
                        throws java.io.IOException

For pre-10.10 database, fileShouldExist will be false. For hard upgraded databases to 10.10, fileShouldExist will be true

Parameters:

path - - this can be root database directory, log or seg0 directory

fileShouldExist -

Throws:

java.io.IOException

testFloatLimits

public void testFloatLimits()
                     throws java.lang.Exception

Verify upgrade behavior DERBY-3398: removing DB2 float limits

Throws:

java.lang.Exception

assertSetError

private void assertSetError(java.sql.PreparedStatement ps,
                            float fv,
                            boolean defer)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

assertSetError

private void assertSetError(java.sql.PreparedStatement ps,
                            double dv,
                            boolean defer)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

assertUpdateError

private void assertUpdateError(java.sql.PreparedStatement ps,
                               float fv,
                               boolean defer)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

assertUpdateError

private void assertUpdateError(java.sql.PreparedStatement ps,
                               double fv,
                               boolean defer)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

verifyDB2Behavior

private void verifyDB2Behavior(java.sql.PreparedStatement psSelect,
                               java.sql.PreparedStatement psInsertReal,
                               java.sql.PreparedStatement psInsertDouble,
                               boolean defer)
                        throws java.sql.SQLException

Check that the old DB2 limits are (still) enforced.

Parameters:

defer - In soft upgrade mode, the checking if deferred after DERBY-3398, i.e. instead of throwing on the DB2 limits when calling ResultSet#updateXXX or PreparedStatement#setXXX, the check throws on ResultSet#updateRow, or {#insertRow}, and similarly on PreparedStatement#execute or #executeUpdate.

Throws:

java.sql.SQLException - if we see some expected error.