org.apache.derbyTesting.functionTests.tests.lang

Class CheckConstraintTest

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

All Implemented Interfaces:

junit.framework.Test

public final class CheckConstraintTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static boolean	funcWasCalled
private static java.lang.String	IMPORT_FILE_NAME

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	checkLargePageSize(java.sql.Statement st, java.lang.String tblName)
static int	func()
private void	setupForBulkInsert(java.sql.Statement s, int limit)
static junit.framework.Test	suite()
void	testBuiltInFunctions()
void	testbulkInsert() DERBY-6453.
void	testCheckConstraints()
void	testDerby6362() Test that CHECK constraint works if it contains unqualified names and the current schema when the constraint is defined is different from the schema in which the table lives.
void	testJira2989()
void	testJira4282()
void	testNotAllowedInCheckConstraints()
void	testPositionalUpdate()
void	testPrimaryKeyPageSizeDerby3947()

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

assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

IMPORT_FILE_NAME

private static final java.lang.String IMPORT_FILE_NAME

See Also:

Constant Field Values

funcWasCalled

static boolean funcWasCalled

Constructor Detail

CheckConstraintTest

public CheckConstraintTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

testNotAllowedInCheckConstraints

public void testNotAllowedInCheckConstraints()
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testCheckConstraints

public void testCheckConstraints()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testPositionalUpdate

public void testPositionalUpdate()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testBuiltInFunctions

public void testBuiltInFunctions()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testJira2989

public void testJira2989()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testJira4282

public void testJira4282()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testPrimaryKeyPageSizeDerby3947

public void testPrimaryKeyPageSizeDerby3947()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

checkLargePageSize

private void checkLargePageSize(java.sql.Statement st,
                                java.lang.String tblName)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testDerby6362

public void testDerby6362()
                   throws java.sql.SQLException

Test that CHECK constraint works if it contains unqualified names and the current schema when the constraint is defined is different from the schema in which the table lives. Regression test case for DERBY-6362.

Throws:

java.sql.SQLException

setupForBulkInsert

private void setupForBulkInsert(java.sql.Statement s,
                                int limit)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testbulkInsert

public void testbulkInsert()
                    throws java.sql.SQLException

DERBY-6453. Exercise hitherto untested code path in InsertResultSet (call to evaluateCheckConstraints from preprocessSourceRow used by bulkInsert) and verify IMPORT with trigger (which would a priori mandate bulk insert, but is changed due to normal inserts due to the presence of a trigger).

Throws:

java.sql.SQLException

func

public static int func()