public final class TriggerGeneralTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
HEX_DIGIT
Pattern for a hexadecimal digit,
cf. http://docs.oracle.com/javase/6/docs/api/java/util/regex/Pattern.html
|
static java.lang.String |
LANG_COLUMN_NOT_FOUND_IN_TABLE |
static java.lang.String |
LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE |
static java.lang.String |
LANG_DUPLICATE_KEY_CONSTRAINT |
static java.lang.String |
LANG_INVALID_OPERATION_ON_SYSTEM_TABLE |
static java.lang.String |
LANG_INVALID_OPERATION_ON_VIEW |
static java.lang.String |
LANG_NO_PARAMS_IN_TRIGGER_ACTION |
static java.lang.String |
LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA |
static java.lang.String |
LANG_OBJECT_ALREADY_EXISTS_IN_OBJECT |
static java.lang.String |
LANG_OBJECT_DOES_NOT_EXIST |
static java.lang.String |
LANG_OBJECT_NOT_FOUND |
static java.lang.String |
LANG_PROVIDER_HAS_DEPENDENT_OBJECT |
static java.lang.String |
LANG_SCHEMA_NOT_EMPTY |
static java.lang.String |
LANG_SYNTAX_ERROR |
static java.lang.String |
LANG_TRIGGER_RECURSION_EXCEEDED |
private static java.io.PrintStream |
out |
private static java.io.ByteArrayOutputStream |
outs |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
TriggerGeneralTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.
|
Modifier and Type | Method and Description |
---|---|
private void |
addPat(java.lang.StringBuilder sb,
java.lang.String pat,
int cnt) |
private static void |
assertTriggerOutput(java.lang.String expected)
Compare the expected output with the fired triggers' output
and reset the print stream used for this purpose.
|
static void |
derby388()
Derby-388: When a set of inserts and updates is performed on a table
and each update fires a trigger that in turn performs other updates,
Derby will sometimes try to recompile the trigger in the middle
of the update process and will throw an NPE when doing so.
|
private boolean |
matchUUIDs(java.lang.String raw) |
private static void |
printTriggerChanges() |
static junit.framework.Test |
suite() |
void |
testTriggersInGeneral() |
static java.lang.String |
triggerFires(java.lang.String string) |
static java.lang.String |
triggerFiresMinimal(java.lang.String string) |
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
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, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
public static final java.lang.String HEX_DIGIT
public static final java.lang.String LANG_DUPLICATE_KEY_CONSTRAINT
public static final java.lang.String LANG_SYNTAX_ERROR
public static final java.lang.String LANG_COLUMN_NOT_FOUND_IN_TABLE
public static final java.lang.String LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA
public static final java.lang.String LANG_OBJECT_NOT_FOUND
public static final java.lang.String LANG_NO_PARAMS_IN_TRIGGER_ACTION
public static final java.lang.String LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE
public static final java.lang.String LANG_OBJECT_DOES_NOT_EXIST
public static final java.lang.String LANG_INVALID_OPERATION_ON_VIEW
public static final java.lang.String LANG_TRIGGER_RECURSION_EXCEEDED
public static final java.lang.String LANG_PROVIDER_HAS_DEPENDENT_OBJECT
public static final java.lang.String LANG_OBJECT_ALREADY_EXISTS_IN_OBJECT
public static final java.lang.String LANG_SCHEMA_NOT_EMPTY
public static final java.lang.String LANG_INVALID_OPERATION_ON_SYSTEM_TABLE
private static java.io.PrintStream out
private static java.io.ByteArrayOutputStream outs
public TriggerGeneralTest(java.lang.String name)
name
- test fixture namepublic static junit.framework.Test suite()
public void testTriggersInGeneral() throws java.lang.Exception
java.lang.Exception
public static void derby388() throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String triggerFiresMinimal(java.lang.String string) throws java.lang.Throwable
java.lang.Throwable
public static java.lang.String triggerFires(java.lang.String string) throws java.lang.Throwable
java.lang.Throwable
private static void printTriggerChanges() throws java.lang.Throwable
java.lang.Throwable
private static void assertTriggerOutput(java.lang.String expected)
private boolean matchUUIDs(java.lang.String raw)
private void addPat(java.lang.StringBuilder sb, java.lang.String pat, int cnt)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.