org.apache.derbyTesting.functionTests.tests.lang

Class RenameIndexTest

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

All Implemented Interfaces:

junit.framework.Test

public class RenameIndexTest
extends BaseJDBCTestCase

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
RenameIndexTest(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	testDuplicateIndexWithPreparedStatement() Test the another feature with PreparedStatement.
void	testDuplicateIndexWithViews() Test RENAME INDEX when there is a duplicate INDEX
void	testExistingIndexName() Test that We cannot Rename an Index With an existing Index name.
void	testRenameColumnWithIndex() column with an index on it can be renamed
void	testRenameIndexOfView() Test to RENAME an INDEX when view is on a table.
void	testRenameIndexWithOpenCursor()
void	testRenameNonExistingIndex() Test that We cannot Rename a non-existing Index.
void	testRenameSystemTableIndex() Test that We cannot Rename a System Table's Index
void	testWithPreparedStatement() Test RENAME INDEX With Prepared Statement.

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

RenameIndexTest

public RenameIndexTest(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

testRenameNonExistingIndex

public void testRenameNonExistingIndex()
                                throws java.sql.SQLException

Test that We cannot Rename a non-existing Index.

Throws:

java.sql.SQLException

testExistingIndexName

public void testExistingIndexName()
                           throws java.sql.SQLException

Test that We cannot Rename an Index With an existing Index name.

Throws:

java.sql.SQLException

testRenameSystemTableIndex

public void testRenameSystemTableIndex()
                                throws java.sql.SQLException

Test that We cannot Rename a System Table's Index

Throws:

java.sql.SQLException

testRenameIndexOfView

public void testRenameIndexOfView()
                           throws java.sql.SQLException

Test to RENAME an INDEX when view is on a table.

Throws:

java.sql.SQLException

testDuplicateIndexWithViews

public void testDuplicateIndexWithViews()
                                 throws java.sql.SQLException

Test RENAME INDEX when there is a duplicate INDEX

Throws:

java.sql.SQLException

testRenameIndexWithOpenCursor

public void testRenameIndexWithOpenCursor()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testWithPreparedStatement

public void testWithPreparedStatement()
                               throws java.sql.SQLException

Test RENAME INDEX With Prepared Statement.

Throws:

java.sql.SQLException

testRenameColumnWithIndex

public void testRenameColumnWithIndex()
                               throws java.sql.SQLException

column with an index on it can be renamed

Throws:

java.sql.SQLException

testDuplicateIndexWithPreparedStatement

public void testDuplicateIndexWithPreparedStatement()
                                             throws java.sql.SQLException

Test the another feature with PreparedStatement.

Throws:

java.sql.SQLException