public class StalePlansTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static int |
STALE_PLAN_CHECK_INTERVAL
The value of derby.language.stalePlanCheckInterval to use in this
test.
|
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
StalePlansTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
private void |
flushRowCount(java.sql.Statement stmt)
Flush the cache so that row count changes are visible.
|
protected void |
setUp()
Create tables and indexes needed by the test cases.
|
static junit.framework.Test |
suite()
Create the test suite.
|
protected void |
tearDown()
Drop tables used in the test.
|
void |
testDerby6724()
Regression test case for DERBY-6724, where an INSERT statement would
fail with a NullPointerException if it had fired a trigger, and it
was detected during execution that the statement plan was stale and
had to be recompiled.
|
void |
testStalePlanCheckIntervalOutOfRange()
Negative test - set stalePlanCheckInterval to a value out of range.
|
void |
testStalePlansOnLargeTable()
Test that the query plan changes when a large table is modified.
|
void |
testStalePlansOnSmallTable()
Test that the query plan is changed when the size of a small table
changes.
|
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, 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, toString
private static final int STALE_PLAN_CHECK_INTERVAL
public static junit.framework.Test suite()
protected void setUp() throws java.sql.SQLException
setUp
in class junit.framework.TestCase
java.sql.SQLException
protected void tearDown() throws java.lang.Exception
tearDown
in class BaseJDBCTestCase
java.lang.Exception
private void flushRowCount(java.sql.Statement stmt) throws java.sql.SQLException
java.sql.SQLException
public void testStalePlanCheckIntervalOutOfRange() throws java.sql.SQLException
java.sql.SQLException
public void testStalePlansOnSmallTable() throws java.sql.SQLException
Note: This test is outdated since Derby now tries to use index scans whenever possible on small tables (primarily to avoid table locks for certain isolation levels, but also because a small table is likely to grow).
java.sql.SQLException
public void testStalePlansOnLargeTable() throws java.sql.SQLException
java.sql.SQLException
public void testDerby6724() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.