public class SystemCatalogTest extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
SystemCatalogTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
static junit.framework.Test |
suite() |
void |
testAutoincrementColumnUpdated()
Test for fix of Derby-318, confirm that it is possible to select
COLUMNDEFAULT from SYSCOLUMNS after a column that is generated by
default has been added.
|
void |
testCheckConsistencyOfSystemCatalogs()
Run SYSCS_UTIL.SYSCS_CHECK_TABLE on each system table.
|
void |
testColumnDatatypesInSystemCatalogs()
Check that column datatypes are reported correctly, both in
embedded and client/server modes
|
void |
testColumnDatatypesOfAllDataTypesInSystemCatalogs()
This test creates a table with all supported datatypes aqnd ensures
that bound embedded and network server return the identical datatypes
for those datatypes.
|
void |
testNewTableInSystemCatalogs()
Check that a newly created table and its columns appear in SYSTABLES and SYSCOLUMNS
|
void |
testNoUserDDLOnSystemTables()
Test that the user cannot execute any DDL statements on the system tables.
|
void |
testOverThirtyCharsInTableName()
Test that table and column names over thirty characters are recorded
properly in the system tables.
|
void |
testPrimaryAndUniqueKeysInSystemCatalogs()
Test that named constraints and unnamed constraints are recorded in the system tables properly.
|
void |
testSystemCatalogColumns()
Check that all the tables for their expected columns.
|
void |
testSystemCatalogIndexes() |
void |
testSystemCatalogsNotUpdatable()
Test that the system tables cannot be changed by various DML statements.
|
void |
testSystemCatalogStoreProperties()
Test various default store properties for the system tables.
|
void |
testSystemCatalogTableTypes()
Test that each system table has a table type of "S".
|
void |
testViewsOfSystemCatalogs()
Test that view creation is recorded in the system tables.
|
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 junit.framework.Test suite()
public void testNoUserDDLOnSystemTables() throws java.sql.SQLException
java.sql.SQLException
public void testSystemCatalogsNotUpdatable() throws java.sql.SQLException
java.sql.SQLException
public void testSystemCatalogStoreProperties() throws java.sql.SQLException
java.sql.SQLException
public void testSystemCatalogTableTypes() throws java.sql.SQLException
java.sql.SQLException
public void testSystemCatalogColumns() throws java.sql.SQLException
java.sql.SQLException
public void testSystemCatalogIndexes() throws java.sql.SQLException
java.sql.SQLException
public void testNewTableInSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
public void testOverThirtyCharsInTableName() throws java.sql.SQLException
java.sql.SQLException
public void testPrimaryAndUniqueKeysInSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
public void testViewsOfSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
public void testColumnDatatypesOfAllDataTypesInSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
public void testColumnDatatypesInSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
public void testAutoincrementColumnUpdated() throws java.sql.SQLException
java.sql.SQLException
public void testCheckConsistencyOfSystemCatalogs() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.