public final class OuterJoinTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
OuterJoinTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.
|
Modifier and Type | Method and Description |
---|---|
private void |
createTestObjects(java.sql.Statement st) |
static junit.framework.Test |
suite() |
void |
testColumnReordering() |
void |
testdDerby2897() |
void |
testdDerby2923() |
void |
testdDerby2924() |
void |
testdDerby2930() |
void |
testdDerby2931() |
void |
testdDerby5164() |
void |
testdDerby5658() |
void |
testdDerby5659() |
void |
testDerby_4471a()
Test that left outer join reordering works as expected.
|
void |
testDerby_4471b()
Test that left outer join reordering works as expected.
|
void |
testDerby_4471c()
Check that ordering actually takes place as well as checking that the
results are correct.
|
void |
testDerby_4471d()
Check that ordering actually takes place (more complex: nested
reordering) as well as checking that the results are correct.
|
void |
testDerby_4712_NPEs()
Test the queries reported in DERBY-4712 as giving null pointer
exceptions.
|
void |
testDerby_4736_nullability()
Test for a follow-up patch for DERBY-4736: verify that nullability in
result set metadata is correct also for columns for the null-producing
side of the LOJ.
|
void |
testDerby_4736()
This fixture would give:
ASSERT FAILED sourceResultSetNumber expected to be >= 0 for T2.X
error in sane mode prior to DERBY-4736 due to a missing rebinding
operation as a result a the LOJ reordering.
|
void |
testDerby_4798_NPE()
Test the queries reported in DERBY-4798 as giving null pointer
exceptions.
|
void |
testInnerJoinXform() |
void |
testLeftRightOuterJoinCombination() |
void |
testMulticolumn() |
void |
testNegative() |
void |
testNestedJoins() |
void |
testOuterJoinWithInsertUpdateDelete() |
void |
testOuterJoinWithinSubquery() |
void |
testOuterJoinWithSubquery() |
void |
testPositive() |
void |
testRightOuterJoinXform() |
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
public OuterJoinTest(java.lang.String name)
public static junit.framework.Test suite()
private void createTestObjects(java.sql.Statement st) throws java.lang.Exception
java.lang.Exception
public void testNegative() throws java.lang.Exception
java.lang.Exception
public void testPositive() throws java.lang.Exception
java.lang.Exception
public void testOuterJoinWithSubquery() throws java.lang.Exception
java.lang.Exception
public void testOuterJoinWithinSubquery() throws java.lang.Exception
java.lang.Exception
public void testNestedJoins() throws java.lang.Exception
java.lang.Exception
public void testLeftRightOuterJoinCombination() throws java.lang.Exception
java.lang.Exception
public void testOuterJoinWithInsertUpdateDelete() throws java.lang.Exception
java.lang.Exception
public void testMulticolumn() throws java.lang.Exception
java.lang.Exception
public void testColumnReordering() throws java.lang.Exception
java.lang.Exception
public void testRightOuterJoinXform() throws java.lang.Exception
java.lang.Exception
public void testInnerJoinXform() throws java.lang.Exception
java.lang.Exception
public void testdDerby2924() throws java.lang.Exception
java.lang.Exception
public void testdDerby2923() throws java.lang.Exception
java.lang.Exception
public void testdDerby2930() throws java.lang.Exception
java.lang.Exception
public void testdDerby2931() throws java.lang.Exception
java.lang.Exception
public void testdDerby2897() throws java.lang.Exception
java.lang.Exception
public void testdDerby5659() throws java.sql.SQLException
java.sql.SQLException
public void testdDerby5658() throws java.lang.Exception
java.lang.Exception
public void testdDerby5164() throws java.lang.Exception
java.lang.Exception
public void testDerby_4471a() throws java.sql.SQLException
java.sql.SQLException
public void testDerby_4471b() throws java.sql.SQLException
java.sql.SQLException
public void testDerby_4471c() throws java.sql.SQLException
java.sql.SQLException
public void testDerby_4471d() throws java.sql.SQLException
java.sql.SQLException
public void testDerby_4736() throws java.sql.SQLException
ASSERT FAILED sourceResultSetNumber expected to be >= 0 for T2.Xerror in sane mode prior to DERBY-4736 due to a missing rebinding operation as a result a the LOJ reordering. Schema and query originally stems from DERBY-4712 (parent issue of DERBY-4736).
java.sql.SQLException
public void testDerby_4736_nullability() throws java.lang.Exception
java.lang.Exception
public void testDerby_4712_NPEs() throws java.lang.Exception
JoinNode#transformOuterJoins
.java.lang.Exception
public void testDerby_4798_NPE() throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.