org.apache.derbyTesting.functionTests.tests.lang

Class TruncateTableTest

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

All Implemented Interfaces:

junit.framework.Test

public class TruncateTableTest
extends BaseJDBCTestCase

Tests for TRUNCATE TABLE.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	ALICE
private static java.lang.String[]	LEGAL_USERS
private static java.lang.String	RUTH
private static java.lang.String	TEST_DBO
private static java.lang.String	UNAUTHORIZED_OPERATION

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
TruncateTableTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private void	cursorMinion(java.sql.Connection cursorConnection, java.sql.Connection truncatorConnection, java.lang.String tableName, java.lang.String truncationStub)
static junit.framework.Test	suite()
void	testConcurrentInvalidation() Test that statement invalidation works when TRUNCATE TABLE statements and other statements accessing the same table execute concurrently.
void	testCursor() Test that TRUNCATE TABLE and DROP TABLE do not cause held cursors to trip across an NPE.
void	testPerms() Test that dbo and owner can truncate table but no-one else can.
void	testSelfReferencing() Test that TRUNCATE TABLE is allowed on a referenced table if it's only referenced by itself.
void	testTruncateWithDeleteTrigger() Test that TRUNCATE TABLE cannot be performed on a table with a delete trigger.
void	testTruncateWithForeignKey() Test that TRUNCATE TABLE isn't allowed on a table referenced by a foreign key constraint on another table.
void	testTruncateWithIndex() Test that TRUNCATE TABLE works when there is an index on one of the columns.

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

Field Detail

TEST_DBO

private static final java.lang.String TEST_DBO

See Also:

Constant Field Values

RUTH

private static final java.lang.String RUTH

See Also:

Constant Field Values

ALICE

private static final java.lang.String ALICE

See Also:

Constant Field Values

LEGAL_USERS

private static final java.lang.String[] LEGAL_USERS

UNAUTHORIZED_OPERATION

private static final java.lang.String UNAUTHORIZED_OPERATION

See Also:

Constant Field Values

Constructor Detail

TruncateTableTest

public TruncateTableTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testTruncateWithIndex

public void testTruncateWithIndex()
                           throws java.sql.SQLException

Test that TRUNCATE TABLE works when there is an index on one of the columns. Verify that default "CONTINUE IDENTITY" semantics are enforced.

Throws:

java.sql.SQLException

testTruncateWithDeleteTrigger

public void testTruncateWithDeleteTrigger()
                                   throws java.lang.Exception

Test that TRUNCATE TABLE cannot be performed on a table with a delete trigger.

Throws:

java.lang.Exception

testTruncateWithForeignKey

public void testTruncateWithForeignKey()
                                throws java.sql.SQLException

Test that TRUNCATE TABLE isn't allowed on a table referenced by a foreign key constraint on another table.

Throws:

java.sql.SQLException

testSelfReferencing

public void testSelfReferencing()
                         throws java.sql.SQLException

Test that TRUNCATE TABLE is allowed on a referenced table if it's only referenced by itself.

Throws:

java.sql.SQLException

testPerms

public void testPerms()
               throws java.lang.Exception

Test that dbo and owner can truncate table but no-one else can.

Throws:

java.lang.Exception

testCursor

public void testCursor()
                throws java.lang.Exception

Test that TRUNCATE TABLE and DROP TABLE do not cause held cursors to trip across an NPE. See DERBY-268.

Throws:

java.lang.Exception

cursorMinion

private void cursorMinion(java.sql.Connection cursorConnection,
                          java.sql.Connection truncatorConnection,
                          java.lang.String tableName,
                          java.lang.String truncationStub)
                   throws java.lang.Exception

Throws:

java.lang.Exception

testConcurrentInvalidation

public void testConcurrentInvalidation()
                                throws java.lang.Exception

Test that statement invalidation works when TRUNCATE TABLE statements and other statements accessing the same table execute concurrently. DERBY-4275.

Throws:

java.lang.Exception