public class ExistsWithSubqueriesTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
EXISTS_PREFIX_1 |
private static java.lang.String |
EXISTS_PREFIX_2 |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ExistsWithSubqueriesTest(java.lang.String name)
Create a test with the given name.
|
Modifier and Type | Method and Description |
---|---|
private void |
checkQuery(java.sql.Statement st,
java.lang.String[][] expRS,
java.lang.String query)
Simple helper method to assert the results of the received
query.
|
private void |
setupDerby3033() |
static junit.framework.Test |
suite()
Return suite with all tests of the class.
|
void |
testCorrelatedSetOps()
Test queries where the set operation has subqueries which are
correlated to the outer query.
|
void |
testDerby3033()
Regression test for Derby-3033.
|
void |
testDerby6408()
Some EXISTS subqueries (and IN subqueries transformed to EXISTS)
returned NULL instead of TRUE or FALSE before DERBY-6408.
|
void |
testNonCorrelatedSetOps()
Test queries where the set operation has subqueries which are not
correlated to the outer query.
|
void |
testSetOpsWithVALUES()
Test queries where the set operation just involves VALUES
expressions.
|
private void |
updateStats(java.sql.Statement st,
java.lang.String tName)
Ensure that the #rows statistics are updated
|
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
private static final java.lang.String EXISTS_PREFIX_1
private static final java.lang.String EXISTS_PREFIX_2
public ExistsWithSubqueriesTest(java.lang.String name)
name
- name of the test.public static junit.framework.Test suite()
public void testSetOpsWithVALUES() throws java.lang.Exception
java.lang.Exception
public void testNonCorrelatedSetOps() throws java.lang.Exception
java.lang.Exception
public void testCorrelatedSetOps() throws java.lang.Exception
java.lang.Exception
private void checkQuery(java.sql.Statement st, java.lang.String[][] expRS, java.lang.String query) throws java.lang.Exception
java.lang.Exception
public void testDerby3033() throws java.lang.Exception
java.lang.Exception
private void updateStats(java.sql.Statement st, java.lang.String tName) throws java.lang.Exception
java.lang.Exception
private void setupDerby3033() throws java.lang.Exception
java.lang.Exception
public void testDerby6408() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.