org.apache.derbyTesting.functionTests.tests.lang

Class RestrictedVTITest

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

org.apache.derbyTesting.functionTests.tests.lang.RestrictedVTITest

All Implemented Interfaces:

junit.framework.Test

public class RestrictedVTITest
extends GeneratedColumnsHelper

Test RestrictedVTIs. See DERBY-4357.

Field Summary

Fields inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, CANT_ADD_IDENTITY, CANT_CONTAIN_NULLS, CANT_MODIFY_IDENTITY, CANT_OVERRIDE_GENERATION_CLAUSE, CANT_REFERENCE_GENERATED_COLUMN, CASCADED_COLUMN_DROP_WARNING, COLUMN_OUT_OF_SCOPE, CONSTRAINT_DROPPED_WARNING, CONSTRAINT_VIOLATION, DUPLICATE_CLAUSE, FORBIDDEN_DROP_TRIGGER, FORBIDDEN_ORDERING_OPERATION, FOREIGN_KEY_VIOLATION, GRANT_REVOKE_NOT_ALLOWED, ILLEGAL_ADD_DEFAULT, ILLEGAL_AGG, ILLEGAL_AGGREGATE, ILLEGAL_COMPARISON, ILLEGAL_DUPLICATE, ILLEGAL_RENAME, ILLEGAL_STORAGE, ILLEGAL_UDT_CLASS, JAVA_EXCEPTION, LACK_COLUMN_PRIV, LACK_EXECUTE_PRIV, LACK_TABLE_PRIV, LACK_USAGE_PRIV, LANG_INVALID_USE_OF_DEFAULT, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_NULL_NEEDS_DATATYPE, NOT_NULL_VIOLATION, OBJECT_DOES_NOT_EXIST, OPERATION_FORBIDDEN, REDUNDANT_CLAUSE, ROUTINE_CANT_ISSUE_SQL, ROUTINE_DEPENDS_ON_TYPE, STRING_TRUNCATION, SYNTAX_ERROR, TABLE_DEPENDS_ON_TYPE, TOO_MUCH_CONTENTION, TRIGGER_DROPPED_WARNING, UNSTABLE_RESULTS, VIEW_DEPENDENCY

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
RestrictedVTITest(java.lang.String name) Create a new instance.

Method Summary

Modifier and Type	Method and Description
private void	assertPR(java.sql.Connection conn, java.lang.String query, java.lang.String[][] expectedResults, java.lang.String expectedProjection, java.lang.String expectedRestriction) Run a query against a RestrictedVTI and verify that the expected projection and restriction are pushed into the VTI.
private void	assertPR(java.sql.Connection conn, java.lang.String query, java.lang.String[][] expectedResults, java.lang.String expectedProjection, java.lang.String expectedRestriction, int expectedQualifiedRowCount) Run a query against a RestrictedVTI, verify that the expected projection and restriction are pushed into the VTI, and verify that the VTI returns the expected number of rows.
private static java.lang.String	doubleQuote(java.lang.String text)
private static java.lang.Integer	i(int intValue)
static IntegerArrayVTI	integerList()
static IntegerArrayVTI	integerListSpecialColNames()
static IntegerArrayVTI	nullableIntegerList()
private boolean	routineExists(java.sql.Connection conn, java.lang.String functionName) Return true if the SQL routine exists
protected void	setUp()
static junit.framework.Test	suite() Construct top level suite in this JUnit test
private boolean	tableExists(java.sql.Connection conn, java.lang.String tableName) Return true if the table exists
void	test_01_heartbeat() Heartbeat test to verify that projections and restrictions are being pushed into RestrictedVTIs.
void	test_02_aliasing() Verify that aliases are correctly mapped to table column names.
void	test_03_allRelationalOperators() Verify that all relational operators are handled.
void	test_04_misc() Miscellaneous conditions.
void	test_05_joins() Test joins to RestrictedVTIs.
void	test_06_distinct() Test DISTINCT.
void	test_07_subqueries() Test subqueries.
void	test_08_having() Predicates in HAVING clauses are not (yet) pushed down to the VTI.
void	test_09_4651() Verify that attempts to create a trailing constant qualification do no cause the VTI to return the wrong rows.
void	test_10_quotes_in_column_names() Test that Restriction.toSQL() returns properly quoted column names.
void	test_11_5369_5370() Verify that Restriction.toSQL() returns usable SQL for all of the comparable types.
void	test_12_6036() Verify that if you wrap a RestrictedVTI in a view, selects from the view pass the restriction on to the RestrictedVTI.
private void	vet5370negative(java.lang.String columnName, java.lang.String columnValue)
private void	vet5370positive(java.sql.Connection conn, java.lang.String columnName, java.lang.String columnValue, java.lang.String expectedValue, java.lang.String negatedValue)
private int	vetDatatypeCount(java.sql.Connection conn, int expectedTypeCount)

Methods inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

assertColumnTypes, assertDeterministic, assertResults, assertResults, chattyPrepare, chattyPrepareCall, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectUpdateRowError, fill, goodStatement, verifyRestrictedDrop, verifyRevokePrivilege

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

Methods inherited from class java.lang.Object

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

Constructor Detail

RestrictedVTITest

public RestrictedVTITest(java.lang.String name)

Create a new instance.

Method Detail

suite

public static junit.framework.Test suite()

Construct top level suite in this JUnit test

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

test_01_heartbeat

public void test_01_heartbeat()
                       throws java.lang.Exception

Heartbeat test to verify that projections and restrictions are being pushed into RestrictedVTIs.

Throws:

java.lang.Exception

test_02_aliasing

public void test_02_aliasing()
                      throws java.lang.Exception

Verify that aliases are correctly mapped to table column names. Also verify that SELECT list expressions cause columns to be included in the column list. Also verify that predicates which aren't qualifiers are not included in the restriction.

Throws:

java.lang.Exception

test_03_allRelationalOperators

public void test_03_allRelationalOperators()
                                    throws java.lang.Exception

Verify that all relational operators are handled.

Throws:

java.lang.Exception

test_04_misc

public void test_04_misc()
                  throws java.lang.Exception

Miscellaneous conditions.

Throws:

java.lang.Exception

test_05_joins

public void test_05_joins()
                   throws java.lang.Exception

Test joins to RestrictedVTIs.

Throws:

java.lang.Exception

test_06_distinct

public void test_06_distinct()
                      throws java.lang.Exception

Test DISTINCT.

Throws:

java.lang.Exception

test_07_subqueries

public void test_07_subqueries()
                        throws java.lang.Exception

Test subqueries.

Throws:

java.lang.Exception

test_08_having

public void test_08_having()
                    throws java.lang.Exception

Predicates in HAVING clauses are not (yet) pushed down to the VTI. Tracked as DERBY-4650.

Throws:

java.lang.Exception

test_09_4651

public void test_09_4651()
                  throws java.lang.Exception

Verify that attempts to create a trailing constant qualification do no cause the VTI to return the wrong rows. Tracked as DERBY-4651.

Throws:

java.lang.Exception

test_10_quotes_in_column_names

public void test_10_quotes_in_column_names()
                                    throws java.lang.Exception

Test that Restriction.toSQL() returns properly quoted column names. DERBY-4654.

Throws:

java.lang.Exception

test_11_5369_5370

public void test_11_5369_5370()
                       throws java.lang.Exception

Verify that Restriction.toSQL() returns usable SQL for all of the comparable types. See DERBY-5369 and DERBY-5370.

Throws:

java.lang.Exception

vet5370positive

private void vet5370positive(java.sql.Connection conn,
                             java.lang.String columnName,
                             java.lang.String columnValue,
                             java.lang.String expectedValue,
                             java.lang.String negatedValue)
                      throws java.lang.Exception

Throws:

java.lang.Exception

doubleQuote

private static java.lang.String doubleQuote(java.lang.String text)

vet5370negative

private void vet5370negative(java.lang.String columnName,
                             java.lang.String columnValue)
                      throws java.lang.Exception

Throws:

java.lang.Exception

vetDatatypeCount

private int vetDatatypeCount(java.sql.Connection conn,
                             int expectedTypeCount)
                      throws java.lang.Exception

Throws:

java.lang.Exception

test_12_6036

public void test_12_6036()
                  throws java.lang.Exception

Verify that if you wrap a RestrictedVTI in a view, selects from the view pass the restriction on to the RestrictedVTI. However, the projection is not passed through to the view so it is not passed on to the RestrictedVTI, as described on DERBY-6036. When that issue is addressed, we should adjust this test case.

Throws:

java.lang.Exception

integerList

public static IntegerArrayVTI integerList()

nullableIntegerList

public static IntegerArrayVTI nullableIntegerList()

i

private static java.lang.Integer i(int intValue)

integerListSpecialColNames

public static IntegerArrayVTI integerListSpecialColNames()

routineExists

private boolean routineExists(java.sql.Connection conn,
                              java.lang.String functionName)
                       throws java.lang.Exception

Return true if the SQL routine exists

Throws:

java.lang.Exception

tableExists

private boolean tableExists(java.sql.Connection conn,
                            java.lang.String tableName)
                     throws java.lang.Exception

Return true if the table exists

Throws:

java.lang.Exception

assertPR

private void assertPR(java.sql.Connection conn,
                      java.lang.String query,
                      java.lang.String[][] expectedResults,
                      java.lang.String expectedProjection,
                      java.lang.String expectedRestriction,
                      int expectedQualifiedRowCount)
               throws java.lang.Exception

Run a query against a RestrictedVTI, verify that the expected projection and restriction are pushed into the VTI, and verify that the VTI returns the expected number of rows.

Throws:

java.lang.Exception

assertPR

private void assertPR(java.sql.Connection conn,
                      java.lang.String query,
                      java.lang.String[][] expectedResults,
                      java.lang.String expectedProjection,
                      java.lang.String expectedRestriction)
               throws java.lang.Exception

Run a query against a RestrictedVTI and verify that the expected projection and restriction are pushed into the VTI.

Throws:

java.lang.Exception