public class CoalesceTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String[] |
ColumnNames |
private static java.lang.String |
NULL_VALUE |
static java.lang.String[][] |
resultDataTypeRulesTable
SQL Reference Guide for DB2 has section titled "Rules for result data types" at the following url
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?
|
private static java.lang.String[][] |
SQLData |
private static java.lang.String[] |
SQLTypes |
private static java.lang.String[] |
TABLES |
private static java.lang.String |
VALID_DATE_STRING |
private static java.lang.String |
VALID_TIME_STRING |
private static java.lang.String |
VALID_TIMESTAMP_STRING |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
CoalesceTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
private void |
dumpRS(java.sql.ResultSet rs,
java.lang.String expectedValue)
supporting methods
|
static boolean |
isClobWithCharAndDateTypeArguments(java.lang.String coalesceString) |
private static boolean |
isSupportedCoalesce(int oneType,
int anotherType) |
static junit.framework.Test |
suite()
Create a suite of tests, run only in embedded since
this is testing server-side behaviour.
|
void |
testAggregateDerby2016() |
void |
testAllDatatypesCombinations() |
void |
testCharCoalesce() |
void |
testCharForBitDataCoalesce() |
void |
testCoalesceSyntax() |
void |
testColumnRemappingDerby4342()
Regression test for DERBY-4342.
|
void |
testCompatibleDatatypesCombinations() |
void |
testDateCoalesce() |
void |
testMiscellaneousCoalesce() |
void |
testMultipleUntypedParameters()
If more than one of the arguments passed to COALESCE are untyped
parameter markers, compilation used to fail with a NullPointerException.
|
void |
testNumericCoalesce() |
void |
testPredicateCategorizationDerby4594()
Regression test for DERBY-4594.
|
void |
testQuantifiedComparison()
Regression test case for DERBY-6577.
|
void |
testTimeCoalesce() |
void |
testTimeStampCoalesce() |
private void |
vetThreeArgCoalesce(java.lang.String sql) |
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
private static java.lang.String VALID_DATE_STRING
private static java.lang.String VALID_TIME_STRING
private static java.lang.String VALID_TIMESTAMP_STRING
private static java.lang.String NULL_VALUE
private static java.lang.String[] SQLTypes
private static java.lang.String[] ColumnNames
private static java.lang.String[][] SQLData
public static final java.lang.String[][] resultDataTypeRulesTable
private static java.lang.String[] TABLES
public static junit.framework.Test suite()
public void testCoalesceSyntax() throws java.lang.Throwable
java.lang.Throwable
public void testCompatibleDatatypesCombinations() throws java.lang.Throwable
java.lang.Throwable
public void testAllDatatypesCombinations() throws java.lang.Throwable
java.lang.Throwable
public void testDateCoalesce() throws java.lang.Throwable
java.lang.Throwable
public void testTimeCoalesce() throws java.lang.Throwable
java.lang.Throwable
public void testTimeStampCoalesce() throws java.lang.Throwable
java.lang.Throwable
public void testNumericCoalesce() throws java.lang.Throwable
java.lang.Throwable
public void testMiscellaneousCoalesce() throws java.sql.SQLException
java.sql.SQLException
public void testCharCoalesce() throws java.lang.Throwable
java.lang.Throwable
public void testCharForBitDataCoalesce() throws java.sql.SQLException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.io.UnsupportedEncodingException
public void testAggregateDerby2016() throws java.sql.SQLException
java.sql.SQLException
public void testColumnRemappingDerby4342() throws java.sql.SQLException
java.sql.SQLException
public void testPredicateCategorizationDerby4594() throws java.sql.SQLException
java.sql.SQLException
public void testMultipleUntypedParameters() throws java.sql.SQLException
java.sql.SQLException
public void testQuantifiedComparison() throws java.sql.SQLException
java.sql.SQLException
private void vetThreeArgCoalesce(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
private void dumpRS(java.sql.ResultSet rs, java.lang.String expectedValue) throws java.sql.SQLException
java.sql.SQLException
public static boolean isClobWithCharAndDateTypeArguments(java.lang.String coalesceString) throws java.lang.Throwable
java.lang.Throwable
private static boolean isSupportedCoalesce(int oneType, int anotherType)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.