org.apache.derbyTesting.functionTests.tests.lang

Class SubqueryTest

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

All Implemented Interfaces:

junit.framework.Test

public class SubqueryTest
extends BaseJDBCTestCase

Test case for subquery.sql.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite()
void	testClone() (select nullable_column ...) is null On of each data type to test clone()
void	testConstants() Test constants in left, right and both sides of the subquery
void	testConversions() Testing conversions
void	testDERBY_2218() Test the fix for DERBY-2218
void	testDERBY_4549() DERBY-4549: NPE in JBitSet
void	testDERBY1007() DERBY-1007: Optimizer for subqueries can return incorrect cost estimates leading to sub-optimal join orders for the outer query.
void	testDERBY781() DERBY-781: Materialize subqueries where possible to avoid creating invariant result sets many times.
void	testDistinct() distinct elimination
void	testEmptyResultSet() empty subquery result set
void	testErrorsInNestedSubqueries() check clean up when errors occur in subqueries insert
void	testExistsNonCorrelated() exists non-correlated negative tests "mis"qualified all
void	testExpressionNonCorrelated() expression subqueries non-correlated negative tests all node
void	testJoinInSubqueries() join in subquery
void	testMatches() Test Matches
void	testNoNeedForCardinalityCheck() tests for not needing to do cardinality check
void	testParameterOnLeft() ?
void	testSimpleCorrelated() Test Simple correlated subqueries
void	testSimpleSubquery() Testing simple subquery for each data type
void	testSubqueriesInPS() Test proper caching of subqueries in prepared statements This section (old Cloudscape reference 'Beetle 5382') tests the fix for a problem where sub-queries were executed not once per execution of the statement, but only once, when the statement was first executed.
void	testSubqueriesInSelect() Test expression subqueries in select list
void	testSubqueriesInSelectList() Test subqueries in select list
void	testSubqueryFlattening() Some extra tests for subquery flattening on table expressions (remapColumnReferencesToExpressions() binary list node
void	testSubqueryInCOALESCE() DERBY-1574: Subquery in COALESCE gives NPE due to preprocess not implemented for that node type
void	testSubqueryInSubquery() Test subquery in subqueries
void	testSubqueryUnderOR() subquery under an or
void	testSubqueryWithClause() subquery with groupby and having clause
void	testSubuqeryInSelectListOfDerivedTable() correlated subquery in select list of a derived table

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

SubqueryTest

public SubqueryTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testExistsNonCorrelated

public void testExistsNonCorrelated()
                             throws java.lang.Exception

exists non-correlated negative tests "mis"qualified all

Throws:

java.lang.Exception

testExpressionNonCorrelated

public void testExpressionNonCorrelated()
                                 throws java.lang.Exception

expression subqueries non-correlated negative tests all node

Throws:

java.lang.Exception

testSimpleSubquery

public void testSimpleSubquery()
                        throws java.lang.Exception

Testing simple subquery for each data type

Throws:

java.lang.Exception

testParameterOnLeft

public void testParameterOnLeft()
                         throws java.lang.Exception

? parameter on left hand side of expression subquery

Throws:

java.lang.Exception

testConversions

public void testConversions()
                     throws java.lang.Exception

Testing conversions

Throws:

java.lang.Exception

testClone

public void testClone()
               throws java.lang.Exception

(select nullable_column ...) is null On of each data type to test clone()

Throws:

java.lang.Exception

testSubqueryInSubquery

public void testSubqueryInSubquery()
                            throws java.lang.Exception

Test subquery in subqueries

Throws:

java.lang.Exception

testSubqueriesInSelect

public void testSubqueriesInSelect()
                            throws java.lang.Exception

Test expression subqueries in select list

Throws:

java.lang.Exception

testConstants

public void testConstants()
                   throws java.lang.Exception

Test constants in left, right and both sides of the subquery

Throws:

java.lang.Exception

testEmptyResultSet

public void testEmptyResultSet()
                        throws java.lang.Exception

empty subquery result set

Throws:

java.lang.Exception

testSubqueriesInSelectList

public void testSubqueriesInSelectList()
                                throws java.lang.Exception

Test subqueries in select list

Throws:

java.lang.Exception

testSubqueryUnderOR

public void testSubqueryUnderOR()
                         throws java.lang.Exception

subquery under an or

Throws:

java.lang.Exception

testDistinct

public void testDistinct()
                  throws java.lang.Exception

distinct elimination

Throws:

java.lang.Exception

testMatches

public void testMatches()
                 throws java.lang.Exception

Test Matches

Throws:

java.lang.Exception

testSimpleCorrelated

public void testSimpleCorrelated()
                          throws java.lang.Exception

Test Simple correlated subqueries

Throws:

java.lang.Exception

testJoinInSubqueries

public void testJoinInSubqueries()
                          throws java.lang.Exception

join in subquery

Throws:

java.lang.Exception

testSubqueriesInPS

public void testSubqueriesInPS()
                        throws java.lang.Exception

Test proper caching of subqueries in prepared statements This section (old Cloudscape reference 'Beetle 5382') tests the fix for a problem where sub-queries were executed not once per execution of the statement, but only once, when the statement was first executed. If the parameter changed between executions or if the data changed between executions then the top level select returned the wrong results.

Throws:

java.lang.Exception

testSubuqeryInSelectListOfDerivedTable

public void testSubuqeryInSelectListOfDerivedTable()
                                            throws java.lang.Exception

correlated subquery in select list of a derived table

Throws:

java.lang.Exception

testSubqueryFlattening

public void testSubqueryFlattening()
                            throws java.lang.Exception

Some extra tests for subquery flattening on table expressions (remapColumnReferencesToExpressions() binary list node

Throws:

java.lang.Exception

testNoNeedForCardinalityCheck

public void testNoNeedForCardinalityCheck()
                                   throws java.lang.Exception

tests for not needing to do cardinality check

Throws:

java.lang.Exception

testErrorsInNestedSubqueries

public void testErrorsInNestedSubqueries()
                                  throws java.lang.Exception

check clean up when errors occur in subqueries insert

Throws:

java.lang.Exception

testSubqueryWithClause

public void testSubqueryWithClause()
                            throws java.lang.Exception

subquery with groupby and having clause

Throws:

java.lang.Exception

testDERBY1007

public void testDERBY1007()
                   throws java.lang.Exception

DERBY-1007: Optimizer for subqueries can return incorrect cost estimates leading to sub-optimal join orders for the outer query. Before the patch for that issue, the following query plan will show T3 first and then T1-- but that's determined by the optimizer to be the "bad" join order. After the fix, the join order will show T1 first, then T3, which is correct (based on the optimizer's estimates).

Throws:

java.lang.Exception

testDERBY781

public void testDERBY781()
                  throws java.lang.Exception

DERBY-781: Materialize subqueries where possible to avoid creating invariant result sets many times. This test case executes a query that that has subqueries twice: the first time the tables have only a few rows in them; the second time they have hundreds of rows in them.

Throws:

java.lang.Exception

testSubqueryInCOALESCE

public void testSubqueryInCOALESCE()
                            throws java.lang.Exception

DERBY-1574: Subquery in COALESCE gives NPE due to preprocess not implemented for that node type

Throws:

java.lang.Exception

testDERBY_2218

public void testDERBY_2218()
                    throws java.lang.Exception

Test the fix for DERBY-2218

Throws:

java.lang.Exception

testDERBY_4549

public void testDERBY_4549()
                    throws java.lang.Exception

DERBY-4549: NPE in JBitSet

Throws:

java.lang.Exception