public class NullIfTest extends BaseJDBCTestCase
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 |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
NullIfTest(java.lang.String name) |
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
|
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[][][] nullIfResults
private static java.lang.String[][][] nullIfResultsClient
private static java.lang.String[][] paramResults
private static java.lang.String[][] paramResultsClient
public void testAllDatatypesCombinations() throws java.sql.SQLException
java.sql.SQLException
public void testParameterForFirstOperandToNullIf() throws java.sql.SQLException
java.sql.SQLException
public void testBooleanExpressions() throws java.sql.SQLException
java.sql.SQLException
public void testNotElimination() throws java.sql.SQLException
java.sql.SQLException
public void testNonDeterministicLeftOperand() throws java.sql.SQLException
java.sql.SQLException
public static junit.framework.Test suite()
public static junit.framework.Test baseSuite(java.lang.String name)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.