org.apache.derbyTesting.functionTests.tests.lang

Class CoalesceTest

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.CoalesceTest

All Implemented Interfaces:

junit.framework.Test

public class CoalesceTest
extends BaseJDBCTestCase

Coalesce/Value tests for various datatypes coalesce/value function takes arguments and returns the first argument that is not null. The arguments are evaluated in the order in which they are specified, and the result of the function is the first argument that is not null. The result can be null only if all the arguments can be null. The selected argument is converted, if necessary, to the attributes of the result.

Field Summary

Fields

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

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
CoalesceTest(java.lang.String name)

Method Summary

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	testTimeCoalesce()
void	testTimeStampCoalesce()
private void	vetThreeArgCoalesce(java.lang.String sql)

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

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

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

Methods inherited from class junit.framework.TestCase

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

VALID_DATE_STRING

private static java.lang.String VALID_DATE_STRING

VALID_TIME_STRING

private static java.lang.String VALID_TIME_STRING

VALID_TIMESTAMP_STRING

private static java.lang.String VALID_TIMESTAMP_STRING

NULL_VALUE

private static java.lang.String NULL_VALUE

SQLTypes

private static java.lang.String[] SQLTypes

ColumnNames

private static java.lang.String[] ColumnNames

SQLData

private static java.lang.String[][] SQLData

resultDataTypeRulesTable

public static final 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?topic=/com.ibm.db2.udb.doc/admin/r0008480.htm I have constructed following table based on various tables and information under "Rules for result data types" This table has FOR BIT DATA TYPES broken out into separate columns for clarity and testing

TABLES

private static java.lang.String[] TABLES

Constructor Detail

CoalesceTest

public CoalesceTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests, run only in embedded since this is testing server-side behaviour.

testCoalesceSyntax

public void testCoalesceSyntax()
                        throws java.lang.Throwable

Throws:

java.lang.Throwable

testCompatibleDatatypesCombinations

public void testCompatibleDatatypesCombinations()
                                         throws java.lang.Throwable

Throws:

java.lang.Throwable

testAllDatatypesCombinations

public void testAllDatatypesCombinations()
                                  throws java.lang.Throwable

Throws:

java.lang.Throwable

testDateCoalesce

public void testDateCoalesce()
                      throws java.lang.Throwable

Throws:

java.lang.Throwable

testTimeCoalesce

public void testTimeCoalesce()
                      throws java.lang.Throwable

Throws:

java.lang.Throwable

testTimeStampCoalesce

public void testTimeStampCoalesce()
                           throws java.lang.Throwable

Throws:

java.lang.Throwable

testNumericCoalesce

public void testNumericCoalesce()
                         throws java.lang.Throwable

Throws:

java.lang.Throwable

testMiscellaneousCoalesce

public void testMiscellaneousCoalesce()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testCharCoalesce

public void testCharCoalesce()
                      throws java.lang.Throwable

Throws:

java.lang.Throwable

testCharForBitDataCoalesce

public void testCharForBitDataCoalesce()
                                throws java.sql.SQLException,
                                       java.io.UnsupportedEncodingException

Throws:

java.sql.SQLException

java.io.UnsupportedEncodingException

testAggregateDerby2016

public void testAggregateDerby2016()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

testColumnRemappingDerby4342

public void testColumnRemappingDerby4342()
                                  throws java.sql.SQLException

Regression test for DERBY-4342. A self-join with COALESCE in the WHERE clause used to fail with a NullPointerException because CoalesceFunctionNode didn't remap column references correctly.

Throws:

java.sql.SQLException

testPredicateCategorizationDerby4594

public void testPredicateCategorizationDerby4594()
                                          throws java.sql.SQLException

Regression test for DERBY-4594. A join with COALESCE in the WHERE clause failed with NullPointerException or with ArrayIndexOutOfBoundsException because the predicates had not been properly categorized in CoalesceFunctionNode.

Throws:

java.sql.SQLException

testMultipleUntypedParameters

public void testMultipleUntypedParameters()
                                   throws java.sql.SQLException

If more than one of the arguments passed to COALESCE are untyped parameter markers, compilation used to fail with a NullPointerException. Fixed in DERBY-6273.

Throws:

java.sql.SQLException

vetThreeArgCoalesce

private void vetThreeArgCoalesce(java.lang.String sql)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

dumpRS

private void dumpRS(java.sql.ResultSet rs,
                    java.lang.String expectedValue)
             throws java.sql.SQLException

supporting methods

Throws:

java.sql.SQLException

isClobWithCharAndDateTypeArguments

public static boolean isClobWithCharAndDateTypeArguments(java.lang.String coalesceString)
                                                  throws java.lang.Throwable

Throws:

java.lang.Throwable

isSupportedCoalesce

private static boolean isSupportedCoalesce(int oneType,
                                           int anotherType)