public class CaseExpressionTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String[][] |
columnReferenceResults |
private static java.lang.String[][] |
nullValueResults |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
CaseExpressionTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
static junit.framework.Test |
suite()
Runs the test fixtures in embedded.
|
void |
testAllDatatypesCombinationsForCaseExpressions() |
private void |
testCaseExpressionQuery(java.sql.Statement st,
java.lang.String[][] expRS,
java.lang.String caseExprBegin,
java.lang.String caseExprEnd)
Execute the received caseExpression on the received Statement
and check the results against the receieved expected array.
|
void |
testDerby3032()
Test fix for DERBY-3032.
|
void |
testMultipleWhens()
Test a query that has many WHEN conditions in it.
|
void |
testWhenNonBoolean()
Test various statements that
|
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
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
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
private static java.lang.String[][] columnReferenceResults
private static java.lang.String[][] nullValueResults
public void testWhenNonBoolean()
public void testAllDatatypesCombinationsForCaseExpressions() throws java.sql.SQLException
java.sql.SQLException
public void testMultipleWhens() throws java.sql.SQLException
java.sql.SQLException
public static junit.framework.Test suite()
private void testCaseExpressionQuery(java.sql.Statement st, java.lang.String[][] expRS, java.lang.String caseExprBegin, java.lang.String caseExprEnd) throws java.sql.SQLException
java.sql.SQLException
public void testDerby3032() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.10 Internals - Copyright © 2004,2014 The Apache Software Foundation. All Rights Reserved.