org.apache.derbyTesting.functionTests.tests.lang

Class StalePlansTest

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

All Implemented Interfaces:

junit.framework.Test

public class StalePlansTest
extends BaseJDBCTestCase

This is the test for stale plan invalidation. The system determines at execution whether the tables used by a DML statement have grown or shrunk significantly, and if so, causes the statement to be recompiled at the next execution.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

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

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

StalePlansTest

public StalePlansTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Create the test suite. This test is not run in client/server mode since it only tests the query plans generated by the embedded driver.

setUp

protected void setUp()
              throws java.sql.SQLException

Create tables and indexes needed by the test cases. Enable collection of run-time statistics.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Drop tables used in the test.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

flushRowCount

private void flushRowCount(java.sql.Statement stmt)
                    throws java.sql.SQLException

Flush the cache so that row count changes are visible. When a dirty page is written to disk, the row count estimate for the container will be updated with the number of added/deleted rows on that page since the last time the page was read from disk or written to disk. We invoke a checkpoint in order to force all dirty pages to be flushed and make all row count changes visible.

Throws:

java.sql.SQLException

testStalePlanCheckIntervalOutOfRange

public void testStalePlanCheckIntervalOutOfRange()
                                          throws java.sql.SQLException

Negative test - set stalePlanCheckInterval to a value out of range.

Throws:

java.sql.SQLException

testStalePlansOnSmallTable

public void testStalePlansOnSmallTable()
                                throws java.sql.SQLException

Test that the query plan is changed when the size of a small table changes.

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

Throws:

java.sql.SQLException

testStalePlansOnLargeTable

public void testStalePlansOnLargeTable()
                                throws java.sql.SQLException

Test that the query plan changes when a large table is modified.

Throws:

java.sql.SQLException