org.apache.derbyTesting.functionTests.tests.lang

Class ConglomerateSharingTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.ConglomerateSharingTest

All Implemented Interfaces:

junit.framework.Test

public final class ConglomerateSharingTest
extends BaseJDBCTestCase

Test for situations in which Derby attempts to "share" physical conglomerates across multiple constraints.

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	COUNT_TABLE_CONGLOMS
private java.lang.String	GET_CONSTRAINT_NAMES

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
ConglomerateSharingTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
private void	checkStatementError(java.lang.String sqlState, java.sql.Statement st, java.lang.String query, java.lang.String ixOrConstraint) Execute the received statement and assert that: 1.
private void	countConglomerates(java.lang.String tableName, java.sql.PreparedStatement countCongloms, int expected) Count the number of physical conglomerates that exist for the received table, and assert that the number found matches the expected number.
static junit.framework.Test	suite() Create a suite of tests.
void	testConstraintDrops() Test various conditions in which a constraint can be dropped, and verify that if the constraint's backing conglomerate is shared, we do the right thing.
void	testConversionToNonUnique() If we have a unique constraint and a non-unique constraint which a) reference the same columns and b) share a single (unique) conglomerate, then test that dropping the unique constraint will convert the physical conglomerate to be non-unique.
void	testUniqueConstraintWithNullsBackingIndex() Test conglomerate sharing when a unique constraint having one or more nullable columns is in play (possible as of DERBY-3330).
private void	verifyConstraints(java.sql.Statement st, java.sql.PreparedStatement constraintNames, java.lang.String tName, java.lang.String constraintName, java.lang.String[][] remainingConstraints, int numRowsExpected) Do various checks to ensure that the constraint has truly been dropped.

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

COUNT_TABLE_CONGLOMS

private final java.lang.String COUNT_TABLE_CONGLOMS

See Also:

Constant Field Values

GET_CONSTRAINT_NAMES

private final java.lang.String GET_CONSTRAINT_NAMES

See Also:

Constant Field Values

Constructor Detail

ConglomerateSharingTest

public ConglomerateSharingTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests.

testConversionToNonUnique

public void testConversionToNonUnique()
                               throws java.sql.SQLException

If we have a unique constraint and a non-unique constraint which a) reference the same columns and b) share a single (unique) conglomerate, then test that dropping the unique constraint will convert the physical conglomerate to be non-unique. This test case is pulled from the repro attached to DERBY-3299.

Throws:

java.sql.SQLException

testConstraintDrops

public void testConstraintDrops()
                         throws java.sql.SQLException

Test various conditions in which a constraint can be dropped, and verify that if the constraint's backing conglomerate is shared, we do the right thing.

Throws:

java.sql.SQLException

testUniqueConstraintWithNullsBackingIndex

public void testUniqueConstraintWithNullsBackingIndex()
                                               throws java.sql.SQLException

Test conglomerate sharing when a unique constraint having one or more nullable columns is in play (possible as of DERBY-3330).

Throws:

java.sql.SQLException

countConglomerates

private void countConglomerates(java.lang.String tableName,
                                java.sql.PreparedStatement countCongloms,
                                int expected)
                         throws java.sql.SQLException

Count the number of physical conglomerates that exist for the received table, and assert that the number found matches the expected number.

Throws:

java.sql.SQLException

checkStatementError

private void checkStatementError(java.lang.String sqlState,
                                 java.sql.Statement st,
                                 java.lang.String query,
                                 java.lang.String ixOrConstraint)
                          throws java.sql.SQLException

Execute the received statement and assert that: 1. The statement fails, and 1. The SQLSTATE for the failure matches the received SQL state, and 2. The failure exception includes the received index/ constraint name in its message. This is intended to be used for uniqueness and foreign key violations, esp. SQLSTATE 23503 and 23505.

Throws:

java.sql.SQLException

verifyConstraints

private void verifyConstraints(java.sql.Statement st,
                               java.sql.PreparedStatement constraintNames,
                               java.lang.String tName,
                               java.lang.String constraintName,
                               java.lang.String[][] remainingConstraints,
                               int numRowsExpected)
                        throws java.sql.SQLException

Do various checks to ensure that the constraint has truly been dropped. Then do simple SELECT queries using optimizer overrides to verify that all expected remaining constraints still exist, and that their backing indexes all contain the expected number of rows.

Throws:

java.sql.SQLException