org.apache.derbyTesting.functionTests.tests.lang

Class CaseExpressionTest

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

All Implemented Interfaces:

junit.framework.Test

public class CaseExpressionTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.concurrent.atomic.AtomicInteger	callCount Count how many times countMe() has been called.
private static java.lang.String[][]	columnReferenceResults
private static java.lang.String[][]	nullValueResults

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static int	countMe(int i) Stored function that keeps track of how many times it has been called.
static junit.framework.Test	suite() Runs the test fixtures in embedded.
void	testAllDatatypesCombinationsForCaseExpressions()
void	testBooleanExpressions() Before DERBY-6423, boolean expressions (such as A OR B, or A AND B) were not accepted in THEN and ELSE clauses.
private void	testCaseExpressionQuery(java.sql.Statement st, java.lang.String[][] expRS, java.lang.String caseExprBegin, java.lang.String caseExprEnd) Execute the received caseExpression on the received Statement and check the results against the receieved expected array.
void	testDerby3032() Test fix for DERBY-3032.
void	testLobAsCaseOperand() Test that large objects can be used as case operands.
void	testMultipleWhens() Test a query that has many WHEN conditions in it.
void	testNotElimination() Verify that NOT elimination produces the correct results.
void	testParameters() Test that parameters can be used in CASE expressions.
void	testQuantifiedComparison() Regression test case for DERBY-6577.
void	testSimpleCaseSyntax() Tests for the simple case syntax added in DERBY-1576.
void	testSingleEvaluationOfCaseOperand() Verify that the case operand expression is evaluated only once per evaluation of the CASE expression.
void	testUntypedNulls() Test how untyped NULLs are handled.
void	testWhenNonBoolean() Test various statements that

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

columnReferenceResults

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

nullValueResults

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

callCount

private static final java.util.concurrent.atomic.AtomicInteger callCount

Count how many times countMe() has been called.

Constructor Detail

CaseExpressionTest

public CaseExpressionTest(java.lang.String name)

Method Detail

testWhenNonBoolean

public void testWhenNonBoolean()

Test various statements that

testAllDatatypesCombinationsForCaseExpressions

public void testAllDatatypesCombinationsForCaseExpressions()
                                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testMultipleWhens

public void testMultipleWhens()
                       throws java.sql.SQLException

Test a query that has many WHEN conditions in it. This is mostly checking for the performance regression filed as DERBY-2986. That regression may not be noticeable in the scope of the full regression suite, but if this test is run standalone then this fixture could still be useful.

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 in THEN and ELSE clauses.

Throws:

java.sql.SQLException

suite

public static junit.framework.Test suite()

Runs the test fixtures in embedded.

Returns:

test suite

testCaseExpressionQuery

private void testCaseExpressionQuery(java.sql.Statement st,
                                     java.lang.String[][] expRS,
                                     java.lang.String caseExprBegin,
                                     java.lang.String caseExprEnd)
                              throws java.sql.SQLException

Execute the received caseExpression on the received Statement and check the results against the receieved expected array.

Throws:

java.sql.SQLException

testDerby3032

public void testDerby3032()
                   throws java.sql.SQLException

Test fix for DERBY-3032. Fix ClassCastException if SQL NULL is returned from conditional.

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

testParameters

public void testParameters()
                    throws java.sql.SQLException

Test that parameters can be used in CASE expressions.

Throws:

java.sql.SQLException

testUntypedNulls

public void testUntypedNulls()
                      throws java.sql.SQLException

Test how untyped NULLs are handled.

Throws:

java.sql.SQLException

testQuantifiedComparison

public void testQuantifiedComparison()
                              throws java.sql.SQLException

Regression test case for DERBY-6577.

Throws:

java.sql.SQLException

testSimpleCaseSyntax

public void testSimpleCaseSyntax()
                          throws java.sql.SQLException

Tests for the simple case syntax added in DERBY-1576.

Throws:

java.sql.SQLException

testSingleEvaluationOfCaseOperand

public void testSingleEvaluationOfCaseOperand()
                                       throws java.sql.SQLException

Verify that the case operand expression is evaluated only once per evaluation of the CASE expression.

Throws:

java.sql.SQLException

countMe

public static int countMe(int i)

Stored function that keeps track of how many times it has been called.

Parameters:

i - an integer

Returns:

the integer i

testLobAsCaseOperand

public void testLobAsCaseOperand()
                          throws java.sql.SQLException

Test that large objects can be used as case operands.

Throws:

java.sql.SQLException