public class UDTTest extends GeneratedColumnsHelper
Test user defined types. See DERBY-651.
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
OBJECT_EXISTS |
static java.lang.String |
TRIGGER_DEPENDS_ON_TYPE |
static java.lang.String |
VIEW_DEPENDS_ON_TYPE |
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 |
---|
UDTTest(java.lang.String name)
Create a new instance.
|
Modifier and Type | Method and Description |
---|---|
static void |
changeIntArray(int newSize,
IntArray[] array) |
private void |
checkPMD(java.sql.Connection conn,
java.lang.String query,
java.lang.String expectedClassName,
int expectedJDBCType,
java.lang.String expectedSQLTypeName,
int expectedPrecision,
int expectedScale)
Check the ParameterMetaData for a statement whose first parameter is a UDT.
|
private void |
checkRSMD(java.sql.Connection conn,
java.lang.String query,
java.lang.String expectedClassName,
int expectedDisplaySize,
int expectedJDBCType,
java.lang.String expectedSQLTypeName,
int expectedPrecision,
int expectedScale)
Check the ResultSetMetaData for a query whose first column is a UDT.
|
private int |
countTableDependencies(java.sql.Connection conn,
java.lang.String tableName)
Get the number of dependencies that a table has
|
static java.lang.Integer |
getIntValue(java.util.HashMap<java.lang.String,java.lang.Integer> map,
java.lang.String key) |
private int |
getScalarInteger(java.sql.PreparedStatement ps)
Get a scalar integer result from a query
|
static java.sql.ResultSet |
hashmapReader() |
private void |
makeGoodTypes(java.sql.Connection conn) |
static java.util.HashMap |
makeHashMap() |
static java.util.HashMap |
makeHashMap(java.lang.String key,
java.lang.Integer value) |
static java.lang.Number |
makeNumber(int arg) |
static void |
oneArgPriceProc(Price price1) |
static java.util.HashMap |
putValue(java.util.HashMap<java.lang.String,java.lang.String> map,
java.lang.String key,
java.lang.String value) |
static junit.framework.Test |
suite()
Construct top level suite in this JUnit test
|
void |
test_01_basicSyntax()
Basic syntax.
|
void |
test_02_basicColumnRetvalParam()
Basic column, return value, and parameter support.
|
void |
test_03_addDropColumn()
Adding and dropping udt columns.
|
void |
test_04_dropTable()
Dropping a whole table which has udt columns.
|
void |
test_05_viewDependencies()
Dependencies of views on UDTs.
|
void |
test_06_casts()
Casting to UDTs.
|
void |
test_07_routineDependencies()
Dependencies of routines on UDTs.
|
void |
test_08_triggerDependencies()
Dependencies of triggers on UDTs.
|
void |
test_09_resultSetMetaData()
Check result set metadata for UDT columns.
|
void |
test_10_parameterMetaData()
Check parameter metadata for UDT parameters.
|
void |
test_11_tableFunctionColumns()
Verify that table functions can have UDT columns.
|
void |
test_12_largeUDTs()
Verify that you can store large objects in UDT columns.
|
void |
test_13_sqlData()
Verify that implementing the SQLData interface does not make an object storeable.
|
void |
test_14_systemClasses()
Verify that you can't bind UDTs to the classes which back the system types.
|
void |
test_15_ordering()
Verify that UDTs have no ordering.
|
void |
test_16_casts()
Verify implicit and explicit casts.
|
void |
test_17_outputParameters()
Verify that you can use UDTs as output parameters in database procedures.
|
void |
test_18_derby6421()
Verify that you can cast a value to an UDT in a generation clause or
a CHECK constraint.
|
static void |
twoArgPriceProc(Price price1,
Price price2) |
private void |
verifyDropRestrictions(java.sql.Connection conn,
java.lang.String createTypeStatement,
java.lang.String dropTypeStatement,
java.lang.String createObjectStatement,
java.lang.String dropObjectStatement,
java.lang.String badDropSQLState)
Verify that a type can't be dropped if it is used by a schema object.
|
private int |
vetDatatypeCount(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
public static final java.lang.String OBJECT_EXISTS
public static final java.lang.String VIEW_DEPENDS_ON_TYPE
public static final java.lang.String TRIGGER_DEPENDS_ON_TYPE
public static junit.framework.Test suite()
public void test_01_basicSyntax() throws java.lang.Exception
Basic syntax.
java.lang.Exception
private void makeGoodTypes(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
public void test_02_basicColumnRetvalParam() throws java.lang.Exception
Basic column, return value, and parameter support.
java.lang.Exception
public void test_03_addDropColumn() throws java.lang.Exception
Adding and dropping udt columns.
java.lang.Exception
public void test_04_dropTable() throws java.lang.Exception
Dropping a whole table which has udt columns.
java.lang.Exception
public void test_05_viewDependencies() throws java.lang.Exception
Dependencies of views on UDTs.
java.lang.Exception
public void test_06_casts() throws java.lang.Exception
Casting to UDTs.
java.lang.Exception
public void test_07_routineDependencies() throws java.lang.Exception
Dependencies of routines on UDTs.
java.lang.Exception
public void test_08_triggerDependencies() throws java.lang.Exception
Dependencies of triggers on UDTs.
java.lang.Exception
public void test_09_resultSetMetaData() throws java.lang.Exception
Check result set metadata for UDT columns.
java.lang.Exception
public void test_10_parameterMetaData() throws java.lang.Exception
Check parameter metadata for UDT parameters.
java.lang.Exception
public void test_11_tableFunctionColumns() throws java.lang.Exception
Verify that table functions can have UDT columns.
java.lang.Exception
public void test_12_largeUDTs() throws java.lang.Exception
Verify that you can store large objects in UDT columns.
java.lang.Exception
public void test_13_sqlData() throws java.lang.Exception
Verify that implementing the SQLData interface does not make an object storeable.
java.lang.Exception
public void test_14_systemClasses() throws java.lang.Exception
Verify that you can't bind UDTs to the classes which back the system types.
java.lang.Exception
private int vetDatatypeCount(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
public void test_15_ordering() throws java.lang.Exception
Verify that UDTs have no ordering.
java.lang.Exception
public void test_16_casts() throws java.lang.Exception
Verify implicit and explicit casts.
java.lang.Exception
public void test_17_outputParameters() throws java.lang.Exception
Verify that you can use UDTs as output parameters in database procedures.
java.lang.Exception
public void test_18_derby6421() throws java.sql.SQLException
java.sql.SQLException
public static void oneArgPriceProc(Price price1)
public static void changeIntArray(int newSize, IntArray[] array)
public static java.util.HashMap makeHashMap()
public static java.util.HashMap makeHashMap(java.lang.String key, java.lang.Integer value)
public static java.util.HashMap putValue(java.util.HashMap<java.lang.String,java.lang.String> map, java.lang.String key, java.lang.String value)
public static java.sql.ResultSet hashmapReader() throws java.lang.Exception
java.lang.Exception
public static java.lang.Number makeNumber(int arg)
public static java.lang.Integer getIntValue(java.util.HashMap<java.lang.String,java.lang.Integer> map, java.lang.String key)
private void verifyDropRestrictions(java.sql.Connection conn, java.lang.String createTypeStatement, java.lang.String dropTypeStatement, java.lang.String createObjectStatement, java.lang.String dropObjectStatement, java.lang.String badDropSQLState) throws java.lang.Exception
java.lang.Exception
private int countTableDependencies(java.sql.Connection conn, java.lang.String tableName) throws java.lang.Exception
java.lang.Exception
private int getScalarInteger(java.sql.PreparedStatement ps) throws java.lang.Exception
java.lang.Exception
private void checkRSMD(java.sql.Connection conn, java.lang.String query, java.lang.String expectedClassName, int expectedDisplaySize, int expectedJDBCType, java.lang.String expectedSQLTypeName, int expectedPrecision, int expectedScale) throws java.lang.Exception
java.lang.Exception
private void checkPMD(java.sql.Connection conn, java.lang.String query, java.lang.String expectedClassName, int expectedJDBCType, java.lang.String expectedSQLTypeName, int expectedPrecision, int expectedScale) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.