org.apache.derbyTesting.functionTests.tests.upgradeTests

Class Changes10_9

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_9

All Implemented Interfaces:

junit.framework.Test

public class Changes10_9
extends UpgradeChange

Upgrade test cases for 10.9.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	Changes10_9.CharRange
(package private) class	Changes10_9.Goal
private class	Changes10_9.SingleChar

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	INVALID_PROVIDER_CHANGE
private Changes10_9.Goal[]	pattern Regexp pattern to match the file name of a jar file stored in the database (version >= 10.9).
private static java.lang.String[]	SUPPORT_FILES_SOURCE
private static java.lang.String	UPGRADE_REQUIRED
private static java.lang.String[][]	USERS Information about users for the test of builtin authentication with configurable hash algorithm.

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

Method Summary

Modifier and Type	Method and Description
private void	assertFileNameShape(java.lang.String fName) assert that fName has the expected shape of a jar file in the database (version >= 10.9).
private void	createSchema(java.lang.String name)
private java.lang.String	getDatabaseProperty(java.sql.Statement s, java.lang.String key)
private java.lang.String	getNewFunctionID(java.sql.Statement s)
private void	initPattern() Initialize a pattern corresponding to: <Derby uuid string>[.]jar[.]G[0-9]+ where: <Derby uuid string> has the form hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh where h id a lower case hex digit.
private void	installJar(java.lang.String resource, java.lang.String jarName)
private boolean	matches(java.lang.String fName, Changes10_9.Goal[] pattern) Poor man's regexp matcher: can match patterns of type below, where start "^" and end "$" is implied: must match whole string.
private void	popAuthenticationAlgorithm(java.sql.Statement s, java.lang.String defaultDigestAlgorithm)
private java.lang.String	pushAuthenticationAlgorithm(java.sql.Statement s)
private void	removeJar(java.lang.String jarName)
private void	replaceJar(java.lang.String resource, java.lang.String jarName)
private void	setDatabaseProperty(java.sql.Statement s, java.lang.String key, java.lang.String value)
private void	setDBClasspath(java.lang.String cp)
private void	setPasswords(java.sql.CallableStatement cs) Set the passwords for all users specified in USERS.
static junit.framework.Test	suite(int phase) Return the suite of tests to test the changes made in 10.7.
void	test_5493() Test the changes introduced to fix correctness problems with sequences.
void	testBuiltinAuthenticationWithConfigurableHash() Make sure builtin authentication doesn't use a hash scheme that's not supported by the old version until the database has been hard upgraded.
void	testDisposableStatisticsExplicit() Verifies the behavior of the update statistics code when faced with "disposable statistics entries".
void	testDropOrphanedStatistics() Verifies that an orphaned statistics entry can be dropped by running the SYSCS_DROP_STATISTICS system procedure.
void	testDropStatisticsProc() Make sure that the drop statistics procedure only appears after hard-upgrade.
void	testJarStorage() For 10.9 and later storage of jar files changed.
void	testNativeAuthentication() Make sure that the catalogs and procedures for NATIVE authentication only appear after hard-upgrade.
void	testNativeLocalAuthentication() Make sure that NATIVE LOCAL authentication can't be turned on before hard-upgrade.
private void	tryCall()
private void	verifyCanConnect(javax.sql.DataSource ds) Verify that all users specified in USERS can connect to the database.
private void	verifyNewLocations(int noOfObjects)
private void	verifyPasswords(java.sql.Connection c) Verify that all passwords for the users in USERS are stored as expected.
private void	vetNativeProcs(java.sql.Statement s, boolean shouldExist)
private void	vetProcs(java.sql.Statement s, java.lang.String procCall, boolean shouldExist)
private void	vetSYSUSERS(java.sql.Statement s, boolean shouldExist)

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

UPGRADE_REQUIRED

private static final java.lang.String UPGRADE_REQUIRED

See Also:

Constant Field Values

INVALID_PROVIDER_CHANGE

private static final java.lang.String INVALID_PROVIDER_CHANGE

See Also:

Constant Field Values

SUPPORT_FILES_SOURCE

private static final java.lang.String[] SUPPORT_FILES_SOURCE

USERS

private static final java.lang.String[][] USERS

Information about users for the test of builtin authentication with configurable hash algorithm. Two-dimensional array of strings where each row contains (1) a user name, (2) a password, (3) the name of a digest algorithm with which the password should be hashed, (4) the hashed password when the old scheme is used, (5) the hashed password when the new, configurable hash scheme is used in databases that don't support the key-stretching extension (DERBY-5539), and (6) the hashed password when configurable hash with key stretching is used.

pattern

private Changes10_9.Goal[] pattern

Regexp pattern to match the file name of a jar file stored in the database (version >= 10.9).

Constructor Detail

Changes10_9

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

testDropStatisticsProc

public void testDropStatisticsProc()
                            throws java.lang.Exception

Make sure that the drop statistics procedure only appears after hard-upgrade.

Throws:

java.lang.Exception

testNativeAuthentication

public void testNativeAuthentication()
                              throws java.lang.Exception

Make sure that the catalogs and procedures for NATIVE authentication only appear after hard-upgrade.

Throws:

java.lang.Exception

vetProcs

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

Throws:

java.lang.Exception

vetSYSUSERS

private void vetSYSUSERS(java.sql.Statement s,
                         boolean shouldExist)
                  throws java.lang.Exception

Throws:

java.lang.Exception

vetNativeProcs

private void vetNativeProcs(java.sql.Statement s,
                            boolean shouldExist)
                     throws java.lang.Exception

Throws:

java.lang.Exception

pushAuthenticationAlgorithm

private java.lang.String pushAuthenticationAlgorithm(java.sql.Statement s)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

popAuthenticationAlgorithm

private void popAuthenticationAlgorithm(java.sql.Statement s,
                                        java.lang.String defaultDigestAlgorithm)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

setDatabaseProperty

private void setDatabaseProperty(java.sql.Statement s,
                                 java.lang.String key,
                                 java.lang.String value)
                          throws java.lang.Exception

Throws:

java.lang.Exception

getDatabaseProperty

private java.lang.String getDatabaseProperty(java.sql.Statement s,
                                             java.lang.String key)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testNativeLocalAuthentication

public void testNativeLocalAuthentication()
                                   throws java.lang.Exception

Make sure that NATIVE LOCAL authentication can't be turned on before hard-upgrade.

Throws:

java.lang.Exception

testBuiltinAuthenticationWithConfigurableHash

public void testBuiltinAuthenticationWithConfigurableHash()
                                                   throws java.sql.SQLException

Make sure builtin authentication doesn't use a hash scheme that's not supported by the old version until the database has been hard upgraded. See DERBY-4483 and DERBY-5539.

Throws:

java.sql.SQLException

setPasswords

private void setPasswords(java.sql.CallableStatement cs)
                   throws java.sql.SQLException

Set the passwords for all users specified in USERS.

Parameters:

cs - a callable statement that sets database properties

Throws:

java.sql.SQLException

verifyPasswords

private void verifyPasswords(java.sql.Connection c)
                      throws java.sql.SQLException

Verify that all passwords for the users in USERS are stored as expected. Raise an assert failure on mismatch.

Parameters:

c - a connection to the database

Throws:

java.sql.SQLException

verifyCanConnect

private void verifyCanConnect(javax.sql.DataSource ds)
                       throws java.sql.SQLException

Verify that all users specified in USERS can connect to the database.

Parameters:

ds - a data source for connecting to the database

Throws:

java.sql.SQLException - if one of the users cannot connect to the database

testJarStorage

public void testJarStorage()
                    throws java.lang.Exception

For 10.9 and later storage of jar files changed. DERBY-5357.

Throws:

java.lang.Exception

createSchema

private void createSchema(java.lang.String name)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

installJar

private void installJar(java.lang.String resource,
                        java.lang.String jarName)
                 throws java.sql.SQLException,
                        java.net.MalformedURLException

Throws:

java.sql.SQLException

java.net.MalformedURLException

replaceJar

private void replaceJar(java.lang.String resource,
                        java.lang.String jarName)
                 throws java.sql.SQLException,
                        java.net.MalformedURLException

Throws:

java.sql.SQLException

java.net.MalformedURLException

removeJar

private void removeJar(java.lang.String jarName)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

setDBClasspath

private void setDBClasspath(java.lang.String cp)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

tryCall

private void tryCall()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

verifyNewLocations

private void verifyNewLocations(int noOfObjects)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

initPattern

private void initPattern()

Initialize a pattern corresponding to:

<Derby uuid string>[.]jar[.]G[0-9]+

where:

<Derby uuid string> has the form hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh

where h id a lower case hex digit.

assertFileNameShape

private void assertFileNameShape(java.lang.String fName)

assert that fName has the expected shape of a jar file in the database (version >= 10.9).

matches

private boolean matches(java.lang.String fName,
                        Changes10_9.Goal[] pattern)

Poor man's regexp matcher: can match patterns of type below, where start "^" and end "$" is implied: must match whole string.

reg.exp: ( '[' <fromchar>-<tochar> ] '+'? ']' | <char> '+'? )*

test_5493

public void test_5493()
               throws java.lang.Exception

Test the changes introduced to fix correctness problems with sequences.

Throws:

java.lang.Exception

getNewFunctionID

private java.lang.String getNewFunctionID(java.sql.Statement s)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testDropOrphanedStatistics

public void testDropOrphanedStatistics()
                                throws java.sql.SQLException

Verifies that an orphaned statistics entry can be dropped by running the SYSCS_DROP_STATISTICS system procedure.

Relevant JIRAs:

• DERBY-4115: Provide a way to drop statistics information
• DERBY-5681: When a foreign key constraint on a table is dropped, the associated statistics row for the conglomerate

DERBY-5702(Creating a foreign key constraint does not automatically create a statistics row if foreign key constraint will share a backing index created for a primay key) is causing a problem for us to test the hanging statistics row with 10.4 and prior releases. Following test relies on having hanging statistics rows which should have been dropped when the constraint owing it was dropped. The test then goes ahead and uses the new drop statisitcs procedure to drop the hanging statistics rows. But because of DERBY-5702, when a constraint is added which will reuse an existing backing index, no statistics row is created for that constraint unless a user were to say use an update statistics stored procedure to create the statistics for that constraint. And later when that constraint is dropped, we will find that because of DERBY-5681, the statistics row never gets dropped. But update statistics stored procedure was not introduced up until 10.5 and because of that, we can't really test for hanging index created through constraints sharing the same backing index prior to 10.5

Throws:

java.sql.SQLException

testDisposableStatisticsExplicit

public void testDisposableStatisticsExplicit()
                                      throws java.sql.SQLException

Verifies the behavior of the update statistics code when faced with "disposable statistics entries".

A disposable statistics entry is a row in SYS.SYSSTATISTICS that has been orphaned (see DERBY-5681) or it is on longer needed by the Derby optimizer (due to internal changes/improvements).

This test expects different things based on the phase:

create

- run statements that will cause disposable statistics entries to be created

soft upgrade

- run the new update statistics code, expecting it to leave the disposable statistics intact

downgrade

- verify that the relevant statistics are present

hard upgrade

- run the new update statistics code, expecting it to get rid of the disposable statistics

Throws:

java.sql.SQLException