org.apache.derbyTesting.functionTests.tests.lang

Class InbetweenTest

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

All Implemented Interfaces:

junit.framework.Test

public final class InbetweenTest
extends BaseJDBCTestCase

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
InbetweenTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
private void	createTestObjects(java.sql.Statement st)
static junit.framework.Test	suite()
void	testBeetle4316()
void	testBetween()
void	testBigInList()
void	testCheckQueries()
void	testDerby4388NotElimination() Regression test cases for DERBY-4388, where the not elimination in BetweenOperatorNode could make column references point to the wrong result sets after optimization, causing NullPointerExceptions.
void	testInBetween()
void	testInList()
void	testNestedQueries()
void	testReproductionBeetle5135()

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

Constructor Detail

InbetweenTest

public InbetweenTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

createTestObjects

private void createTestObjects(java.sql.Statement st)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testBetween

public void testBetween()
                 throws java.lang.Exception

Throws:

java.lang.Exception

testInList

public void testInList()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

testInBetween

public void testInBetween()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testBigInList

public void testBigInList()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testCheckQueries

public void testCheckQueries()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testNestedQueries

public void testNestedQueries()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testBeetle4316

public void testBeetle4316()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testReproductionBeetle5135

public void testReproductionBeetle5135()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testDerby4388NotElimination

public void testDerby4388NotElimination()
                                 throws java.sql.SQLException

Regression test cases for DERBY-4388, where the not elimination in BetweenOperatorNode could make column references point to the wrong result sets after optimization, causing NullPointerExceptions.

Throws:

java.sql.SQLException