public class UDAPermsTest extends GeneratedColumnsHelper
Test permissions on user-defined aggregates. See DERBY-672.
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
ALICE |
private static java.lang.String |
BAD_DISTINCT |
private static java.lang.String |
FRANK |
private static java.lang.String |
IMPLICIT_CAST_ERROR |
private static java.lang.String[] |
LEGAL_USERS |
private static java.lang.String |
MISSING_ROUTINE |
private static java.lang.String |
PARSE_ERROR |
private static java.lang.String |
RUTH |
private static java.lang.String |
TEST_DBO |
private static java.lang.String |
TONY |
BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, 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, LEXICAL_ERROR, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NO_GENERIC_PERMISSION, NO_SELECT_OR_UPDATE_PERMISSION, NO_TABLE_PERMISSION, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_IMPLEMENTED, 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
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
UDAPermsTest(java.lang.String name)
Create a new instance.
|
Modifier and Type | Method and Description |
---|---|
private void |
createSchema_005(java.sql.Connection ruthConnection) |
private void |
dropSchema_005(java.sql.Connection ruthConnection) |
static junit.framework.Test |
suite()
Construct top level suite in this JUnit test
|
void |
test_001_basicGrant()
Test that you need USAGE privilege on an aggregate in order to invoke it.
|
void |
test_002_basicRevoke()
Test that USAGE privilege can't be revoked if it would make objects
unusable by their owners.
|
void |
test_003_typePrivs()
Test that you need USAGE privilege on user-defined types in order to use them in
user-defined aggregates.
|
void |
test_004_emptySchema()
Test that we fixed an NPE in resolving function names when the
schema hasn't been created yet.
|
void |
test_005_builtinAggregators()
Test that anyone can run the modern, builtin system aggregates
which implement org.apache.derby.agg.Aggregator.
|
private void |
vetBuiltinAgg_005(java.sql.Connection conn,
java.lang.String aggName,
java.lang.String[][] expectedInexactResults,
java.lang.String[][] expectedExactResults) |
private void |
vetBuiltinAgg_005(java.sql.Connection conn,
java.lang.String aggName,
java.lang.String tableName,
java.lang.String[][] expectedResults) |
private void |
vetBuiltinNegative_005(java.sql.Connection conn,
java.lang.String aggName) |
private void |
vetStatsBuiltins_005(java.sql.Connection conn) |
assertColumnTypes, assertDeterministic, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectNoWarning, expectUpdateRowError, fill, verifyRestrictedDrop, verifyRevokePrivilege
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
private static final java.lang.String TEST_DBO
private static final java.lang.String RUTH
private static final java.lang.String ALICE
private static final java.lang.String FRANK
private static final java.lang.String TONY
private static final java.lang.String[] LEGAL_USERS
private static final java.lang.String MISSING_ROUTINE
private static final java.lang.String IMPLICIT_CAST_ERROR
private static final java.lang.String PARSE_ERROR
private static final java.lang.String BAD_DISTINCT
public static junit.framework.Test suite()
public void test_001_basicGrant() throws java.lang.Exception
Test that you need USAGE privilege on an aggregate in order to invoke it. and in order to declare objects which mention that type.
java.lang.Exception
public void test_002_basicRevoke() throws java.lang.Exception
Test that USAGE privilege can't be revoked if it would make objects unusable by their owners.
java.lang.Exception
public void test_003_typePrivs() throws java.lang.Exception
Test that you need USAGE privilege on user-defined types in order to use them in user-defined aggregates.
java.lang.Exception
public void test_004_emptySchema() throws java.lang.Exception
Test that we fixed an NPE in resolving function names when the schema hasn't been created yet.
java.lang.Exception
public void test_005_builtinAggregators() throws java.lang.Exception
Test that anyone can run the modern, builtin system aggregates which implement org.apache.derby.agg.Aggregator.
java.lang.Exception
private void vetStatsBuiltins_005(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private void vetBuiltinAgg_005(java.sql.Connection conn, java.lang.String aggName, java.lang.String[][] expectedInexactResults, java.lang.String[][] expectedExactResults) throws java.lang.Exception
java.lang.Exception
private void vetBuiltinAgg_005(java.sql.Connection conn, java.lang.String aggName, java.lang.String tableName, java.lang.String[][] expectedResults) throws java.lang.Exception
java.lang.Exception
private void vetBuiltinNegative_005(java.sql.Connection conn, java.lang.String aggName) throws java.lang.Exception
java.lang.Exception
private void createSchema_005(java.sql.Connection ruthConnection) throws java.lang.Exception
java.lang.Exception
private void dropSchema_005(java.sql.Connection ruthConnection) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.