public class AnsiTrimTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
AnsiTrimTest(java.lang.String name)
Create a test case with the given name.
|
Modifier and Type | Method and Description |
---|---|
static void |
decorate(java.sql.Statement s) |
private void |
positiveTest(java.lang.String sql,
java.lang.Object expected) |
static junit.framework.Test |
suite() |
void |
testCharIsNull() |
void |
testColumnsWithConstant()
trim a column with a constant trim char.
|
void |
testSourceIsEmpty() |
void |
testSourceIsNull() |
void |
testSourceIsSingleChar() |
void |
testTrimCharIsExpr()
Use a few expressions as the trim character.
|
void |
testTrimFromClobColumn()
A clob column is the input source.
|
void |
testTrimResultIsEmpty()
All the characters are trimmed.
|
void |
testTrimSourceIsExpr()
Use a few different expressions as the trim source.
|
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 AnsiTrimTest(java.lang.String name)
name
- of the test case.public static void decorate(java.sql.Statement s) throws java.sql.SQLException
java.sql.SQLException
public static junit.framework.Test suite()
public void testColumnsWithConstant() throws java.sql.SQLException
java.sql.SQLException
public void testTrimCharIsExpr() throws java.sql.SQLException
java.sql.SQLException
public void testTrimFromClobColumn() throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
public void testTrimSourceIsExpr() throws java.sql.SQLException
java.sql.SQLException
public void testTrimResultIsEmpty() throws java.sql.SQLException
java.sql.SQLException
public void testSourceIsEmpty() throws java.sql.SQLException
java.sql.SQLException
public void testSourceIsNull() throws java.sql.SQLException
java.sql.SQLException
public void testSourceIsSingleChar() throws java.sql.SQLException
java.sql.SQLException
public void testCharIsNull() throws java.sql.SQLException
java.sql.SQLException
private void positiveTest(java.lang.String sql, java.lang.Object expected) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.