org.apache.derbyTesting.functionTests.tests.lang

Class CurrentOfTest

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

All Implemented Interfaces:

junit.framework.Test

public class CurrentOfTest
extends BaseJDBCTestCase

This tests the current of statements, i.e. delete where current of and update where current of. Not done in ij since the cursor names may not be stable.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
CurrentOfTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
private void	cursorChange(java.lang.String sqlState, java.lang.String initialCursor, java.lang.String positionedStatement, java.lang.String changeToCursor) Run cursorChange() with an application provided name and a system provided name.
private void	cursorChange(java.lang.String sqlState, java.lang.String cursorName, java.lang.String initialCursor, java.lang.String positionedStatement, java.lang.String changeToCursor) Test what happens to a positioned update when the cursor it is compiled against changes to the SQL provided, changeToSQL.
static int	doubleValue(int i)
private int	recompile(java.lang.String positionedSQL, java.lang.String changeSQL1, java.lang.String changeSQL2) Execute a select and then the positioned statement against it.
protected void	setUp() Set the fixture up with tables t and s and insert 4 rows in table t.
static junit.framework.Test	suite() Create a suite of tests.
protected void	tearDown() Tear-down the fixture by removing the tables
void	testCursorChangeToDifferentTable() Change the current cursor from the one the positioned UPDATE was compiled against to one that is against a different table.
void	testCursorChangeToReadOnly() Change the current cursor from the one the positioned UPDATE/DELETE was compiled against to one that is read only against the same table.
void	testCursorChangeUpdateList() Change the current cursor from the one the positioned UPDATE and DELETE was compiled against to one that only has a subset of the columns being updatable.
void	testDelete() Test delete with the current of statements.
void	testDeleteRecompileCreateIndex() Test the positioned delete correctly recompiles when an index is added.
void	testReadOnlyCursors() Test read only statements.
void	testUpdate() Test update with the current of statements.
void	testUpdateRecompileChangeFunction() Test the positioned update correctly recompiles when the definition of a function is changed.
void	testUpdateRecompileCreateIndex() Test the positioned update correctly recompiles when an index is added.
static int	tripleValue(int i)

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

CurrentOfTest

public CurrentOfTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests.

setUp

protected void setUp()
              throws java.sql.SQLException

Set the fixture up with tables t and s and insert 4 rows in table t.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear-down the fixture by removing the tables

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testReadOnlyCursors

public void testReadOnlyCursors()
                         throws java.sql.SQLException

Test read only statements.

Throws:

java.sql.SQLException

testDelete

public void testDelete()
                throws java.sql.SQLException

Test delete with the current of statements. Also do some negative testing to see whether correct exceptions are thrown or not.

Throws:

java.lang.Exception

java.sql.SQLException

testUpdate

public void testUpdate()
                throws java.sql.SQLException

Test update with the current of statements. Also do some negative testing to see whether correct exceptions are thrown or not.

Throws:

java.lang.Exception

java.sql.SQLException

testUpdateRecompileCreateIndex

public void testUpdateRecompileCreateIndex()
                                    throws java.lang.Exception

Test the positioned update correctly recompiles when an index is added.

Throws:

java.lang.Exception

testUpdateRecompileChangeFunction

public void testUpdateRecompileChangeFunction()
                                       throws java.lang.Exception

Test the positioned update correctly recompiles when the definition of a function is changed.

Throws:

java.lang.Exception

testDeleteRecompileCreateIndex

public void testDeleteRecompileCreateIndex()
                                    throws java.lang.Exception

Test the positioned delete correctly recompiles when an index is added.

Throws:

java.lang.Exception

recompile

private int recompile(java.lang.String positionedSQL,
                      java.lang.String changeSQL1,
                      java.lang.String changeSQL2)
               throws java.sql.SQLException

Execute a select and then the positioned statement against it. Then execute the changeSQL that should force a recompile of the positioned statement. Then execute the positioned statement again and finally check all is ok with check table. The positioned statements are executed against the rows that have I=180 and I=456.

Returns:

the value of I for the first row that had the positioned statement executed against it, ie. before the change SQl was executed.

Throws:

java.sql.SQLException

testCursorChangeUpdateList

public void testCursorChangeUpdateList()
                                throws java.sql.SQLException

Change the current cursor from the one the positioned UPDATE and DELETE was compiled against to one that only has a subset of the columns being updatable.

Throws:

java.sql.SQLException

testCursorChangeToReadOnly

public void testCursorChangeToReadOnly()
                                throws java.sql.SQLException

Change the current cursor from the one the positioned UPDATE/DELETE was compiled against to one that is read only against the same table.

Throws:

java.sql.SQLException

testCursorChangeToDifferentTable

public void testCursorChangeToDifferentTable()
                                      throws java.sql.SQLException

Change the current cursor from the one the positioned UPDATE was compiled against to one that is against a different table. test FAILS - once fixed should be renamed to lose the FAIL prefix. Fails as the positioned update wor

Throws:

java.sql.SQLException

cursorChange

private void cursorChange(java.lang.String sqlState,
                          java.lang.String initialCursor,
                          java.lang.String positionedStatement,
                          java.lang.String changeToCursor)
                   throws java.sql.SQLException

Run cursorChange() with an application provided name and a system provided name.

Throws:

java.sql.SQLException

cursorChange

private void cursorChange(java.lang.String sqlState,
                          java.lang.String cursorName,
                          java.lang.String initialCursor,
                          java.lang.String positionedStatement,
                          java.lang.String changeToCursor)
                   throws java.sql.SQLException

Test what happens to a positioned update when the cursor it is compiled against changes to the SQL provided, changeToSQL. This test first prepares a cursor initialCursor using with the given name (or system name if null is passed in) A cursor is opened and a positioned update is opened that updates. If sqlState is null then no error is expected and thus the positioned statement must update a single row. Otherwise sqlState is the exected exception for the update. If no error is expected then three rows will be either updated or deleted depending on the positioned statement. If an error is expected then two rows will be updated or deleted.

Throws:

java.sql.SQLException

doubleValue

public static int doubleValue(int i)

tripleValue

public static int tripleValue(int i)