public class SubqueryTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
SubqueryTest(java.lang.String name) |
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
|
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 static junit.framework.Test suite()
public void testExistsNonCorrelated() throws java.lang.Exception
java.lang.Exception
public void testExpressionNonCorrelated() throws java.lang.Exception
java.lang.Exception
public void testSimpleSubquery() throws java.lang.Exception
java.lang.Exception
public void testParameterOnLeft() throws java.lang.Exception
java.lang.Exception
public void testConversions() throws java.lang.Exception
java.lang.Exception
public void testClone() throws java.lang.Exception
java.lang.Exception
public void testSubqueryInSubquery() throws java.lang.Exception
java.lang.Exception
public void testSubqueriesInSelect() throws java.lang.Exception
java.lang.Exception
public void testConstants() throws java.lang.Exception
java.lang.Exception
public void testEmptyResultSet() throws java.lang.Exception
java.lang.Exception
public void testSubqueriesInSelectList() throws java.lang.Exception
java.lang.Exception
public void testSubqueryUnderOR() throws java.lang.Exception
java.lang.Exception
public void testDistinct() throws java.lang.Exception
java.lang.Exception
public void testMatches() throws java.lang.Exception
java.lang.Exception
public void testSimpleCorrelated() throws java.lang.Exception
java.lang.Exception
public void testJoinInSubqueries() throws java.lang.Exception
java.lang.Exception
public void testSubqueriesInPS() throws java.lang.Exception
java.lang.Exception
public void testSubuqeryInSelectListOfDerivedTable() throws java.lang.Exception
java.lang.Exception
public void testSubqueryFlattening() throws java.lang.Exception
java.lang.Exception
public void testNoNeedForCardinalityCheck() throws java.lang.Exception
java.lang.Exception
public void testErrorsInNestedSubqueries() throws java.lang.Exception
java.lang.Exception
public void testSubqueryWithClause() throws java.lang.Exception
java.lang.Exception
public void testDERBY1007() throws java.lang.Exception
java.lang.Exception
public void testDERBY781() throws java.lang.Exception
java.lang.Exception
public void testSubqueryInCOALESCE() throws java.lang.Exception
java.lang.Exception
public void testDERBY_2218() throws java.lang.Exception
java.lang.Exception
public void testDERBY_4549() throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.