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

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	assertBytes(byte[] expected, byte[] actual)
private void	checkValStartInc(java.sql.Statement st, java.lang.String nm, java.lang.String v, java.lang.String s, java.lang.String inc)
private void	checkWarning(java.sql.Statement st, java.lang.String expectedWarning)
private void	createTableAndInsertData(java.sql.Statement s, java.lang.String tableName, java.lang.String column1, java.lang.String column2)
private void	createTestObjects(java.sql.Statement st)
private byte[]	makeBytes(int seed, int length)
private int	numberOfRowsInSysdepends(java.sql.Statement st)
static junit.framework.Test	suite()
void	test_5679_longRows() More tests for DERBY-5679.
void	test_5679_manyColumns() More tests for DERBY-5679.
void	test_5679() Verify that rollback works properly if a column with a null default is added and then the table is updated.
void	testAddColumn()
void	testAddConstraint()
void	testAlterColumn()
void	testAlterTableAndSysdepends()
void	testDerby5157_addColumnWithDefaultValue() Test that an ALTER TABLE statement that adds a new column with a default value, doesn't fail if the schema name, table name or column name contains a double quote character.
void	testDerby5157_changeIncrement() Test that an ALTER TABLE statement that changes the increment value of an identity column, doesn't fail if the schema name, table name or column name contains a double quote character.
void	testDropColumn()
void	testDropColumnTriggerDependency()
void	testDropConstraint()
void	testDropObjects()
void	testJira2371()
void	testJira3175()
void	testJira3177()
void	testJira3355()
void	testJira4256()
void	testRenameAutoincrementColumn() See DERBY-4693 for a case where this was broken.
void	testTemporaryTable()
void	testTriggersAndSynonyms()
void	testWithSchema()
private void	triggersExist(java.sql.Statement st, java.lang.String[][] expectedTriggers)
private void	vetBytes_5679(java.sql.Connection conn, byte[][] expected)

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, tearDown, 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, setUp, toString

Methods inherited from class java.lang.Object

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

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

testRenameAutoincrementColumn

public void testRenameAutoincrementColumn()
                                   throws java.lang.Exception

See DERBY-4693 for a case where this was broken.

Throws:

java.lang.Exception

checkValStartInc

private void checkValStartInc(java.sql.Statement st,
                              java.lang.String nm,
                              java.lang.String v,
                              java.lang.String s,
                              java.lang.String inc)
                       throws java.lang.Exception

Throws:

java.lang.Exception

testAlterColumn

public void testAlterColumn()
                     throws java.lang.Exception

Throws:

java.lang.Exception

testAlterTableAndSysdepends

public void testAlterTableAndSysdepends()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testTriggersAndSynonyms

public void testTriggersAndSynonyms()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testDropColumnTriggerDependency

public void testDropColumnTriggerDependency()
                                     throws java.lang.Exception

Throws:

java.lang.Exception

testDropColumn

public void testDropColumn()
                    throws java.lang.Exception

Throws:

java.lang.Exception

createTableAndInsertData

private void createTableAndInsertData(java.sql.Statement s,
                                      java.lang.String tableName,
                                      java.lang.String column1,
                                      java.lang.String column2)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

numberOfRowsInSysdepends

private int numberOfRowsInSysdepends(java.sql.Statement st)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

triggersExist

private void triggersExist(java.sql.Statement st,
                           java.lang.String[][] expectedTriggers)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

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

testDerby5157_addColumnWithDefaultValue

public void testDerby5157_addColumnWithDefaultValue()
                                             throws java.sql.SQLException

Test that an ALTER TABLE statement that adds a new column with a default value, doesn't fail if the schema name, table name or column name contains a double quote character.

Throws:

java.sql.SQLException

testDerby5157_changeIncrement

public void testDerby5157_changeIncrement()
                                   throws java.sql.SQLException

Test that an ALTER TABLE statement that changes the increment value of an identity column, doesn't fail if the schema name, table name or column name contains a double quote character.

Throws:

java.sql.SQLException

test_5679

public void test_5679()
               throws java.lang.Exception

Verify that rollback works properly if a column with a null default is added and then the table is updated. See DERBY-5679.

Throws:

java.lang.Exception

test_5679_manyColumns

public void test_5679_manyColumns()
                           throws java.lang.Exception

More tests for DERBY-5679. Verify with a lot of columns.

Throws:

java.lang.Exception

test_5679_longRows

public void test_5679_longRows()
                        throws java.lang.Exception

More tests for DERBY-5679. Verify with long rows.

Throws:

java.lang.Exception

makeBytes

private byte[] makeBytes(int seed,
                         int length)

vetBytes_5679

private void vetBytes_5679(java.sql.Connection conn,
                           byte[][] expected)
                    throws java.lang.Exception

Throws:

java.lang.Exception

assertBytes

private void assertBytes(byte[] expected,
                         byte[] actual)
                  throws java.lang.Exception

Throws:

java.lang.Exception