org.apache.derbyTesting.functionTests.tests.lang

Class SubqueryFlatteningTest

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

All Implemented Interfaces:

junit.framework.Test

public class SubqueryFlatteningTest
extends BaseJDBCTestCase

This test verifies that flattening of subqueries works correctly. The test cases in subqueryFlattening.sql could be moved to this class when they are converted to JUnit.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	checkExistsJoin(java.sql.Statement s, java.lang.String sql, java.lang.String[][] rows, boolean flattenable) Check that a query returns the expected rows and whether or not it was flattened to an exists join (or not exists join).
private void	enableRuntimeStatistics(java.sql.Statement s) Enable collection of runtime statistics in the current connection.
protected void	setUp() Set up the test environment.
static junit.framework.Test	suite()
void	testAllNotFlattenableToNotExists() DERBY-4001: Test that some ALL subqueries that used to be flattened to a not exists join and return incorrect results, are not flattened.
void	testNotExistsFlattenablePredicatesNotPulled() DERBY-4001: Test that certain NOT EXISTS/NOT IN/ALL subqueries are flattened, and that their predicates are not pulled out.
void	testNotInNotFlattenableToNotExists() DERBY-4001: Test that some NOT IN subqueries that used to be flattened to a not exists join and return incorrect results, are not flattened.

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, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SubqueryFlatteningTest

public SubqueryFlatteningTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.sql.SQLException

Set up the test environment. Turn off auto-commit so that all the test data can easily be removed by the rollback performed in BaseJDBCTestCase.tearDown().

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

enableRuntimeStatistics

private void enableRuntimeStatistics(java.sql.Statement s)
                              throws java.sql.SQLException

Enable collection of runtime statistics in the current connection.

Parameters:

s - the statement to use for enabling runtime statistics

Throws:

java.sql.SQLException

checkExistsJoin

private void checkExistsJoin(java.sql.Statement s,
                             java.lang.String sql,
                             java.lang.String[][] rows,
                             boolean flattenable)
                      throws java.sql.SQLException

Check that a query returns the expected rows and whether or not it was flattened to an exists join (or not exists join). An error is raised if wrong results are returned or if the query plan is not the expected one.

Parameters:

s - the statement on which the query is executed

sql - the query text

rows - the expected result

flattenable - whether or not we expect the query to be flattened to a (not) exists join

Throws:

java.sql.SQLException - if a database error occurs

junit.framework.AssertionFailedError - if the wrong results are returned from the query, or if the query plan is not as expected

testNotExistsFlattenablePredicatesNotPulled

public void testNotExistsFlattenablePredicatesNotPulled()
                                                 throws java.sql.SQLException

DERBY-4001: Test that certain NOT EXISTS/NOT IN/ALL subqueries are flattened, and that their predicates are not pulled out. Their predicates are known to be always false, so when they are (correctly) applied on the subquery, they will cause all the rows from the outer query to be returned. If the predicates are (incorrectly) pulled out to the outer query, the query won't return any rows at all. DERBY-4001.

Throws:

java.sql.SQLException

testAllNotFlattenableToNotExists

public void testAllNotFlattenableToNotExists()
                                      throws java.sql.SQLException

DERBY-4001: Test that some ALL subqueries that used to be flattened to a not exists join and return incorrect results, are not flattened. These queries should not be flattened because the generated NOT EXISTS JOIN condition or some of the subquery's predicates could be pushed down into the left side of the join, which is not allowed in a not exists join because the predicates have a completely different effect if they're used on one side of the join than if they're used on the other side of the join.

Throws:

java.sql.SQLException

testNotInNotFlattenableToNotExists

public void testNotInNotFlattenableToNotExists()
                                        throws java.sql.SQLException

DERBY-4001: Test that some NOT IN subqueries that used to be flattened to a not exists join and return incorrect results, are not flattened. These queries should not be flattened because the generated NOT EXISTS JOIN condition or some of the subquery's predicates could be pushed down into the left side of the join, which is not allowed in a not exists join because the predicates have a completely different effect if they're used on one side of the join than if they're used on the other side of the join.

Throws:

java.sql.SQLException