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	testBooleanExpressions() Before DERBY-6423, boolean expressions (such as A OR B, or A AND B) were not accepted as arguments to NULLIF.
void	testNonDeterministicLeftOperand() Test how NULLIF behaves if the left operand calls a non-deterministic function.
void	testNotElimination() Verify that NOT elimination produces the correct results.
void	testParameterForFirstOperandToNullIf() Test NULLIF with parameter as first operand

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

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

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

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, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

testBooleanExpressions

public void testBooleanExpressions()
                            throws java.sql.SQLException

Before DERBY-6423, boolean expressions (such as A OR B, or A AND B) were not accepted as arguments to NULLIF.

Throws:

java.sql.SQLException

testNotElimination

public void testNotElimination()
                        throws java.sql.SQLException

Verify that NOT elimination produces the correct results. DERBY-6563.

Throws:

java.sql.SQLException

testNonDeterministicLeftOperand

public void testNonDeterministicLeftOperand()
                                     throws java.sql.SQLException

Test how NULLIF behaves if the left operand calls a non-deterministic function. DERBY-6569.

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)