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

(package private) java.sql.Connection	conn
(package private) java.sql.CallableStatement	cSt
(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
(package private) java.sql.Statement	st

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

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

Method Summary

static junit.framework.Test	suite()
void	testBuiltInFunctions()
void	testCheckConstraints()
void	testJira2989()
void	testJira4282()
void	testNotAllowedInCheckConstraints()
void	testPositionalUpdate()

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

sqlWarn

java.sql.SQLWarning sqlWarn

pSt

java.sql.PreparedStatement pSt

cSt

java.sql.CallableStatement cSt

st

java.sql.Statement st

expRS

java.lang.String[][] expRS

expColNames

java.lang.String[] expColNames

conn

java.sql.Connection conn

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