OuterJoinTest (Apache Derby V10.10 Test Javadoc)

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

All Implemented Interfaces:: junit.framework.Test

public final class OuterJoinTest
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

OuterJoinTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.

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

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
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()`

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
  - OuterJoinTest
```
public OuterJoinTest(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.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testNegative
```
public void testNegative()
                  throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testPositive
```
public void testPositive()
                  throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testOuterJoinWithSubquery
```
public void testOuterJoinWithSubquery()
                               throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testOuterJoinWithinSubquery
```
public void testOuterJoinWithinSubquery()
                                 throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testNestedJoins
```
public void testNestedJoins()
                     throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testLeftRightOuterJoinCombination
```
public void testLeftRightOuterJoinCombination()
                                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testOuterJoinWithInsertUpdateDelete
```
public void testOuterJoinWithInsertUpdateDelete()
                                         throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testMulticolumn
```
public void testMulticolumn()
                     throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testColumnReordering
```
public void testColumnReordering()
                          throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testRightOuterJoinXform
```
public void testRightOuterJoinXform()
                             throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testInnerJoinXform
```
public void testInnerJoinXform()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby2924
```
public void testdDerby2924()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby2923
```
public void testdDerby2923()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby2930
```
public void testdDerby2930()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby2931
```
public void testdDerby2931()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby2897
```
public void testdDerby2897()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby5659
```
public void testdDerby5659()
                    throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testdDerby5658
```
public void testdDerby5658()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testdDerby5164
```
public void testdDerby5164()
                    throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testDerby_4471a
```
public void testDerby_4471a()
                     throws java.sql.SQLException
```
    Test that left outer join reordering works as expected. This fixture is the first repro mentioned for this issue, DERBY-4471. It checks for correct results, and should fail prior to applying issue patch due to erroneous reordering.
    The results asserted in these tests for DERBY-4471 are the same as Derby gives without the reordering enabled and the same as Postgres yields.
    Note that the patch also opens up for correct reorderings of some queries in the seen in the original lojreorder.sql test (converted to JUnit as LojReorderTest in this patch) that did not happen earlier, in addition to denying the wrong ones documented in DERBY-4471 and tested below. These new reorderings are tested, cf the comments in LojReorderTest. Look for the string 4471.
    
    Throws:
    
    java.sql.SQLException
  - testDerby_4471b
```
public void testDerby_4471b()
                     throws java.sql.SQLException
```
    Test that left outer join reordering works as expected. The schema here is taken from the another issue which also saw this error; DERBY-4712/DERBY-4736. This fixture checks for correct results. The first query should fail prior to applying issue patch due to erroneous reordering, the second is OK to reorder (and would be reordered also prior to the patch).
    
    Throws:
    
    java.sql.SQLException
  - testDerby_4471c
```
public void testDerby_4471c()
                     throws java.sql.SQLException
```
    Check that ordering actually takes place as well as checking that the results are correct.
    
    Throws:
    
    java.sql.SQLException
  - testDerby_4471d
```
public void testDerby_4471d()
                     throws java.sql.SQLException
```
    Check that ordering actually takes place (more complex: nested reordering) as well as checking that the results are correct.
    
    Throws:
    
    java.sql.SQLException
  - testDerby_4736
```
public void testDerby_4736()
                    throws java.sql.SQLException
```
    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. Schema and query originally stems from DERBY-4712 (parent issue of DERBY-4736).
    Throws:
    
    java.sql.SQLException
  - testDerby_4736_nullability
```
public void testDerby_4736_nullability()
                                throws java.lang.Exception
```
    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.
    
    Throws:
    
    java.lang.Exception
  - testDerby_4712_NPEs
```
public void testDerby_4712_NPEs()
                         throws java.lang.Exception
```
    Test the queries reported in DERBY-4712 as giving null pointer exceptions. Should fail with NPE before the fix went in. For bug explanation, see the JIRA issue and JoinNode#transformOuterJoins.
    
    Throws:
    
    java.lang.Exception
  - testDerby_4798_NPE
```
public void testDerby_4798_NPE()
                        throws java.lang.Exception
```
    Test the queries reported in DERBY-4798 as giving null pointer exceptions. Should fail with NPE before the fix went in.
    
    Throws:
    
    java.lang.Exception

Class OuterJoinTest

Field Summary

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

Constructor Summary

Method Summary

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

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Constructor Detail

OuterJoinTest

Method Detail

suite

createTestObjects

testNegative

testPositive

testOuterJoinWithSubquery

testOuterJoinWithinSubquery

testNestedJoins

testLeftRightOuterJoinCombination

testOuterJoinWithInsertUpdateDelete

testMulticolumn

testColumnReordering

testRightOuterJoinXform

testInnerJoinXform

testdDerby2924

testdDerby2923

testdDerby2930

testdDerby2931

testdDerby2897

testdDerby5659

testdDerby5658

testdDerby5164

testDerby_4471a

testDerby_4471b

testDerby_4471c

testDerby_4471d

testDerby_4736

testDerby_4736_nullability

testDerby_4712_NPEs

testDerby_4798_NPE