org.apache.derbyTesting.functionTests.tests.lang

Class OptimizerOverridesTest

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

All Implemented Interfaces:

junit.framework.Test

public class OptimizerOverridesTest
extends BaseJDBCTestCase

Test the optimizer overrides.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String[][]	FULL_TABLE

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite()
void	testBadFormats() Negative tests for bad formats.
void	testBadProperties() Test bad properties.
void	testComparision() Comparisons that can't get pushed down.
void	testDependenceOnConstraint() Verify that statements are dependent on specified constraint.
void	testDependenceOnIndex() Verify that statements are dependent on specified index.
void	testFragmentsAsComments() Make sure following fragments get treated as comments.
void	testInsertModeValue() Negative test. insertModeValue is not available to a user and hence will give a syntax error.
void	testInvalidJoinStrategy()
void	testJoin()
void	testMixedIndexAndConstraint() Test both index and constraint.
void	testNestedLoopJoinStrategy()
void	testNonExistingPropertyValues() Test not existing values of property.
void	testNullValue()
void	testPropertyForUpdate() Index which includes columns in for update of list.
void	testSpell() Test case insensitivity, spelling sensitivity and delimited index.

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, tearDown, 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, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

FULL_TABLE

private static final java.lang.String[][] FULL_TABLE

Constructor Detail

OptimizerOverridesTest

public OptimizerOverridesTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testBadFormats

public void testBadFormats()
                    throws java.sql.SQLException

Negative tests for bad formats.

Throws:

java.sql.SQLException

testBadProperties

public void testBadProperties()
                       throws java.sql.SQLException

Test bad properties.

Throws:

java.sql.SQLException

testNonExistingPropertyValues

public void testNonExistingPropertyValues()
                                   throws java.sql.SQLException

Test not existing values of property.

Throws:

java.sql.SQLException

testFragmentsAsComments

public void testFragmentsAsComments()
                             throws java.sql.SQLException

Make sure following fragments get treated as comments.

Throws:

java.sql.SQLException

testMixedIndexAndConstraint

public void testMixedIndexAndConstraint()
                                 throws java.sql.SQLException

Test both index and constraint.

Throws:

java.sql.SQLException

testPropertyForUpdate

public void testPropertyForUpdate()
                           throws java.sql.SQLException

Index which includes columns in for update of list.

Throws:

java.sql.SQLException

testInvalidJoinStrategy

public void testInvalidJoinStrategy()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

testDependenceOnIndex

public void testDependenceOnIndex()
                           throws java.sql.SQLException

Verify that statements are dependent on specified index.

Throws:

java.sql.SQLException

testDependenceOnConstraint

public void testDependenceOnConstraint()
                                throws java.sql.SQLException

Verify that statements are dependent on specified constraint.

Throws:

java.sql.SQLException

testSpell

public void testSpell()
               throws java.sql.SQLException

Test case insensitivity, spelling sensitivity and delimited index.

Throws:

java.sql.SQLException

testNullValue

public void testNullValue()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testJoin

public void testJoin()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

testComparision

public void testComparision()
                     throws java.sql.SQLException

Comparisons that can't get pushed down.

Throws:

java.sql.SQLException

testNestedLoopJoinStrategy

public void testNestedLoopJoinStrategy()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testInsertModeValue

public void testInsertModeValue()
                         throws java.sql.SQLException

Negative test. insertModeValue is not available to a user and hence will give a syntax error. There are some undocumented properties which are allowed within Derby engine only and insertModeValue is one of them.

Throws:

java.sql.SQLException