org.apache.derbyTesting.functionTests.tests.lang
Class AlterTableTest

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

All Implemented Interfaces:

junit.framework.Test

public final class AlterTableTest
extends BaseJDBCTestCase

Field Summary

(package private) java.sql.Connection	conn
(package private) java.sql.CallableStatement	cSt
(package private) java.sql.DatabaseMetaData	dbmd
(package private) java.lang.String[]	expColNames
(package private) java.lang.String[][]	expRS
(package private) java.sql.PreparedStatement	pSt
(package private) java.sql.ResultSet	rs
(package private) java.sql.ResultSetMetaData	rsmd
(package private) java.sql.SQLWarning	sqlWarn

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

AlterTableTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.

Method Summary

private void	checkWarning(java.sql.Statement st, java.lang.String expectedWarning)
private void	createTestObjects(java.sql.Statement st)
static junit.framework.Test	suite()
void	testAddColumn()
void	testAddConstraint()
void	testAlterColumn()
void	testDropColumn()
void	testDropConstraint()
void	testDropObjects()
void	testJira2371()
void	testJira3175()
void	testJira3177()
void	testJira3355()
void	testJira4256()
void	testTemporaryTable()
void	testWithSchema()

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertTableRowCount, assertUpdateCount, assertUpdateCount, checkAllConsistency, checkEstimatedRowCount, commit, createStatement, createStatement, createStatement, dropTable, dropTable, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

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

alarm, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertSecurityManager, assertThrowableEquals, execJavaCmd, fail, getFailureFolder, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeSystemProperty, runBare, setSystemProperty, traceit

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runTest, setName, setUp, toString

Methods inherited from class junit.framework.Assert

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, fail, fail

Methods inherited from class java.lang.Object

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

Field Detail

rs

java.sql.ResultSet rs

rsmd

java.sql.ResultSetMetaData rsmd

dbmd

java.sql.DatabaseMetaData dbmd

sqlWarn

java.sql.SQLWarning sqlWarn

pSt

java.sql.PreparedStatement pSt

cSt

java.sql.CallableStatement cSt

conn

java.sql.Connection conn

expRS

java.lang.String[][] expRS

expColNames

java.lang.String[] expColNames

Constructor Detail

AlterTableTest

public AlterTableTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

createTestObjects

private void createTestObjects(java.sql.Statement st)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

checkWarning

private void checkWarning(java.sql.Statement st,
                          java.lang.String expectedWarning)
                   throws java.lang.Exception

Throws:

java.lang.Exception

testAddColumn

public void testAddColumn()
                   throws java.lang.Exception

Throws:

java.lang.Exception

testDropObjects

public void testDropObjects()
                     throws java.lang.Exception

Throws:

java.lang.Exception

testAddConstraint

public void testAddConstraint()
                       throws java.lang.Exception

Throws:

java.lang.Exception

testDropConstraint

public void testDropConstraint()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testWithSchema

public void testWithSchema()
                    throws java.lang.Exception

Throws:

java.lang.Exception

testTemporaryTable

public void testTemporaryTable()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testAlterColumn

public void testAlterColumn()
                     throws java.lang.Exception

Throws:

java.lang.Exception

testDropColumn

public void testDropColumn()
                    throws java.lang.Exception

Throws:

java.lang.Exception

testJira3175

public void testJira3175()
                  throws java.lang.Exception

Throws:

java.lang.Exception

testJira3177

public void testJira3177()
                  throws java.lang.Exception

Throws:

java.lang.Exception

testJira2371

public void testJira2371()
                  throws java.lang.Exception

Throws:

java.lang.Exception

testJira3355

public void testJira3355()
                  throws java.lang.Exception

Throws:

java.lang.Exception

testJira4256

public void testJira4256()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException