org.apache.derbyTesting.functionTests.tests.lang

Class RenameTableTest

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.RenameTableTest

All Implemented Interfaces:

junit.framework.Test

public class RenameTableTest
extends BaseJDBCTestCase

Various tests for RENAME TABLE

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	DEFERRED_FOREIGN_VIOLATION
private static java.lang.String	DEFERRED_PRIMARY_VIOLATION
private static java.lang.String	FOREIGN_VIOLATION
private static java.lang.String	PRIMARY_VIOLATION
private static java.lang.String	USER_ERROR

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static void	runStatementAndRaiseError(java.lang.String text)
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	test_6672_1() Test that you can rename a table referenced by a foreign key.
void	testExistedNameForRenameTable() Tests that we can't rename a table with an existed table name
void	testRenameInvalidation_derby_4479() Tests that rename table invalidates stored statement plans (DERBY-4479).
void	testRenameNonExistingTable() Tests that we can't rename a Non-Existing Table.
void	testRenameSystemTable() Tests that we cannot rename a System Table.
void	testRenameTableWithTriggersOnIt() Test that we can RENAME a TABLE when there is trigger defined on it.
void	testRenameTableWithViews() Tests that we cannot rename a View
void	testRenameWithCheckConstraintsOnIt() RENAME TABLE should fail when check constraints on it.
void	testRenameWithIndex() Tests that We can rename a table when there is an index defined on it
void	testRenameWithPreparedStatement() Test Rename Table With PreparedStatement.

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, 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, isJava8, 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, toString

Methods inherited from class java.lang.Object

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

Field Detail

PRIMARY_VIOLATION

private static final java.lang.String PRIMARY_VIOLATION

See Also:

Constant Field Values

FOREIGN_VIOLATION

private static final java.lang.String FOREIGN_VIOLATION

See Also:

Constant Field Values

DEFERRED_PRIMARY_VIOLATION

private static final java.lang.String DEFERRED_PRIMARY_VIOLATION

See Also:

Constant Field Values

DEFERRED_FOREIGN_VIOLATION

private static final java.lang.String DEFERRED_FOREIGN_VIOLATION

See Also:

Constant Field Values

USER_ERROR

private static final java.lang.String USER_ERROR

See Also:

Constant Field Values

Constructor Detail

RenameTableTest

public RenameTableTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleans up and closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testRenameNonExistingTable

public void testRenameNonExistingTable()
                                throws java.sql.SQLException

Tests that we can't rename a Non-Existing Table.

Throws:

java.sql.SQLException

testExistedNameForRenameTable

public void testExistedNameForRenameTable()
                                   throws java.sql.SQLException

Tests that we can't rename a table with an existed table name

Throws:

java.sql.SQLException

testRenameSystemTable

public void testRenameSystemTable()
                           throws java.sql.SQLException

Tests that we cannot rename a System Table.

Throws:

java.sql.SQLException

testRenameTableWithViews

public void testRenameTableWithViews()
                              throws java.sql.SQLException

Tests that we cannot rename a View

Throws:

java.sql.SQLException

testRenameWithIndex

public void testRenameWithIndex()
                         throws java.sql.SQLException

Tests that We can rename a table when there is an index defined on it

Throws:

java.sql.SQLException

testRenameWithPreparedStatement

public void testRenameWithPreparedStatement()
                                     throws java.sql.SQLException

Test Rename Table With PreparedStatement.

Throws:

java.sql.SQLException

testRenameTableWithTriggersOnIt

public void testRenameTableWithTriggersOnIt()
                                     throws java.sql.SQLException

Test that we can RENAME a TABLE when there is trigger defined on it.

Throws:

java.sql.SQLException

testRenameWithCheckConstraintsOnIt

public void testRenameWithCheckConstraintsOnIt()
                                        throws java.sql.SQLException

RENAME TABLE should fail when check constraints on it.

Throws:

java.sql.SQLException

testRenameInvalidation_derby_4479

public void testRenameInvalidation_derby_4479()
                                       throws java.sql.SQLException

Tests that rename table invalidates stored statement plans (DERBY-4479). By issuing the *identical* create table statement after the rename, we check to see whether the compiled statements from the first create table statement were properly invalidated by the rename.

Throws:

java.sql.SQLException

test_6672_1

public void test_6672_1()
                 throws java.lang.Exception

Test that you can rename a table referenced by a foreign key. See DERBY-6672.

Throws:

java.lang.Exception

runStatementAndRaiseError

public static void runStatementAndRaiseError(java.lang.String text)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException