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 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
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
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	testRenameOnDependencies() We can't Rename a Table When there is a foreign key constraint depended on it.
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, 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, 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, toString

Methods inherited from class java.lang.Object

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

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 cleanups & 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

testRenameOnDependencies

public void testRenameOnDependencies()
                              throws java.sql.SQLException

We can't Rename a Table When there is a foreign key constraint depended on it.

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