org.apache.derbyTesting.functionTests.tests.lang

Class NullIfTest

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

All Implemented Interfaces:

junit.framework.Test

public class NullIfTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String[][][]	nullIfResults
private static java.lang.String[][][]	nullIfResultsClient
private static java.lang.String[][]	paramResults
private static java.lang.String[][]	paramResultsClient

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	baseSuite(java.lang.String name)
static junit.framework.Test	suite() Runs the test fixtures in embedded and client.
void	testAllDatatypesCombinations() Test NULLIF combinations on all datatypes
void	testParameterForFirstOperandToNullIf() Test NULLIF with parameter as first operand

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

nullIfResults

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

nullIfResultsClient

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

paramResults

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

paramResultsClient

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

Constructor Detail

NullIfTest

public NullIfTest(java.lang.String name)

Method Detail

testAllDatatypesCombinations

public void testAllDatatypesCombinations()
                                  throws java.sql.SQLException

Test NULLIF combinations on all datatypes

Throws:

java.sql.SQLException

testParameterForFirstOperandToNullIf

public void testParameterForFirstOperandToNullIf()
                                          throws java.sql.SQLException

Test NULLIF with parameter as first operand

Throws:

java.sql.SQLException

suite

public static junit.framework.Test suite()

Runs the test fixtures in embedded and client.

Returns:

test suite

baseSuite

public static junit.framework.Test baseSuite(java.lang.String name)