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

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

All Implemented Interfaces:

junit.framework.Test

public class AlterColumnTest
extends BaseJDBCTestCase

Test cases for altering columns.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

AlterColumnTest(java.lang.String name)

Method Summary

static junit.framework.Test	suite()
void	testAlterDefault() Test ALTER COLUMN default
private static void	tryAndExpect(java.sql.PreparedStatement d, java.sql.PreparedStatement i, java.sql.PreparedStatement s, java.lang.String e) Auxiliary method: Execute the delete statement d to clean table, then the insert statement i to exercise the default mechanism, then check via the select statement s, that the value inserted is e.

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

Constructor Detail

AlterColumnTest

public AlterColumnTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testAlterDefault

public void testAlterDefault()
                      throws java.sql.SQLException

Test ALTER COLUMN default

Throws:

java.sql.SQLException

tryAndExpect

private static void tryAndExpect(java.sql.PreparedStatement d,
                                 java.sql.PreparedStatement i,
                                 java.sql.PreparedStatement s,
                                 java.lang.String e)
                          throws java.sql.SQLException

Auxiliary method: Execute the delete statement d to clean table, then the insert statement i to exercise the default mechanism, then check via the select statement s, that the value inserted is e.

Parameters:

d - delete statement

i - insert statement

s - select statement

e - expected value as a string

Throws:

java.sql.SQLException