org.apache.derbyTesting.functionTests.tests.jdbcapi
Class URCoveringIndexTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.apache.derbyTesting.junit.BaseTestCase
              org.apache.derbyTesting.junit.BaseJDBCTestCase
                  org.apache.derbyTesting.functionTests.tests.jdbcapi.URCoveringIndexTest

All Implemented Interfaces:

junit.framework.Test

public class URCoveringIndexTest
extends BaseJDBCTestCase

Tests updatable result sets when there is a index that includes all data for the query (covering index). DERBY-1087

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

URCoveringIndexTest(java.lang.String name)
Creates a new instance of SURBaseTest

Method Summary

void	setUp() Set up the connection to the database.
static junit.framework.Test	suite()
void	testUpdateUpdatedTupleFOPositioned() Updates a previously updated row with a covering index using positioned updates and forward only result sets.
void	testUpdateUpdatedTupleFOUpdateRow() Updates a previously updated row with a covering index using updateRow and forward only result sets.
void	testUpdateUpdatedTupleScrollPostitioned() Updates a previously updated row with a covering index using positioned updates and scrollable result sets.
void	testUpdateUpdatedTupleScrollUpdateRow() Updates a previously updated row with a covering index using updateRow and scrollable result sets.
private void	testUpdateUpdatedTupleWithCoveringIndex(boolean scroll, boolean usePositionedUpdate)

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertTableRowCount, assertUpdateCount, assertUpdateCount, checkAllConsistency, checkEstimatedRowCount, commit, createStatement, createStatement, createStatement, dropTable, dropTable, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

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

alarm, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertSecurityManager, assertThrowableEquals, execJavaCmd, fail, getFailureFolder, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeSystemProperty, runBare, setSystemProperty, traceit

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runTest, setName, toString

Methods inherited from class junit.framework.Assert

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

URCoveringIndexTest

public URCoveringIndexTest(java.lang.String name)

Creates a new instance of SURBaseTest

Method Detail

suite

public static junit.framework.Test suite()

setUp

public void setUp()
           throws java.lang.Exception

Set up the connection to the database.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

testUpdateUpdatedTupleWithCoveringIndex

private void testUpdateUpdatedTupleWithCoveringIndex(boolean scroll,
                                                     boolean usePositionedUpdate)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testUpdateUpdatedTupleScrollPostitioned

public void testUpdateUpdatedTupleScrollPostitioned()
                                             throws java.sql.SQLException

Updates a previously updated row with a covering index using positioned updates and scrollable result sets.

Throws:

java.sql.SQLException

testUpdateUpdatedTupleScrollUpdateRow

public void testUpdateUpdatedTupleScrollUpdateRow()
                                           throws java.sql.SQLException

Updates a previously updated row with a covering index using updateRow and scrollable result sets.

Throws:

java.sql.SQLException

testUpdateUpdatedTupleFOPositioned

public void testUpdateUpdatedTupleFOPositioned()
                                        throws java.sql.SQLException

Updates a previously updated row with a covering index using positioned updates and forward only result sets.

Throws:

java.sql.SQLException

testUpdateUpdatedTupleFOUpdateRow

public void testUpdateUpdatedTupleFOUpdateRow()
                                       throws java.sql.SQLException

Updates a previously updated row with a covering index using updateRow and forward only result sets.

Throws:

java.sql.SQLException