org.apache.derbyTesting.functionTests.tests.lang

Class SystemCatalogTest

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

All Implemented Interfaces:

junit.framework.Test

public class SystemCatalogTest
extends BaseJDBCTestCase

Tests concerning the system catalogs. Retaining comment from previous .sql test: RESOLVE - add selects from sysdepends when simplified

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

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.

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

Constructor Detail

SystemCatalogTest

public SystemCatalogTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testNoUserDDLOnSystemTables

public void testNoUserDDLOnSystemTables()
                                 throws java.sql.SQLException

Test that the user cannot execute any DDL statements on the system tables.

Throws:

java.sql.SQLException

testSystemCatalogsNotUpdatable

public void testSystemCatalogsNotUpdatable()
                                    throws java.sql.SQLException

Test that the system tables cannot be changed by various DML statements.

Throws:

java.sql.SQLException

testSystemCatalogStoreProperties

public void testSystemCatalogStoreProperties()
                                      throws java.sql.SQLException

Test various default store properties for the system tables.

Throws:

java.sql.SQLException

testSystemCatalogTableTypes

public void testSystemCatalogTableTypes()
                                 throws java.sql.SQLException

Test that each system table has a table type of "S".

Throws:

java.sql.SQLException

testSystemCatalogColumns

public void testSystemCatalogColumns()
                              throws java.sql.SQLException

Check that all the tables for their expected columns.

Throws:

java.sql.SQLException

testSystemCatalogIndexes

public void testSystemCatalogIndexes()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testNewTableInSystemCatalogs

public void testNewTableInSystemCatalogs()
                                  throws java.sql.SQLException

Check that a newly created table and its columns appear in SYSTABLES and SYSCOLUMNS

Throws:

java.sql.SQLException

testOverThirtyCharsInTableName

public void testOverThirtyCharsInTableName()
                                    throws java.sql.SQLException

Test that table and column names over thirty characters are recorded properly in the system tables.

Throws:

java.sql.SQLException

testPrimaryAndUniqueKeysInSystemCatalogs

public void testPrimaryAndUniqueKeysInSystemCatalogs()
                                              throws java.sql.SQLException

Test that named constraints and unnamed constraints are recorded in the system tables properly.

Throws:

java.sql.SQLException

testViewsOfSystemCatalogs

public void testViewsOfSystemCatalogs()
                               throws java.sql.SQLException

Test that view creation is recorded in the system tables.

Throws:

java.sql.SQLException

testColumnDatatypesOfAllDataTypesInSystemCatalogs

public void testColumnDatatypesOfAllDataTypesInSystemCatalogs()
                                                       throws java.sql.SQLException

This test creates a table with all supported datatypes aqnd ensures that bound embedded and network server return the identical datatypes for those datatypes. DERBY-5407

Throws:

java.sql.SQLException

testColumnDatatypesInSystemCatalogs

public void testColumnDatatypesInSystemCatalogs()
                                         throws java.sql.SQLException

Check that column datatypes are reported correctly, both in embedded and client/server modes

Throws:

java.sql.SQLException

testAutoincrementColumnUpdated

public void testAutoincrementColumnUpdated()
                                    throws java.sql.SQLException

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.

Throws:

java.sql.SQLException

testCheckConsistencyOfSystemCatalogs

public void testCheckConsistencyOfSystemCatalogs()
                                          throws java.sql.SQLException

Run SYSCS_UTIL.SYSCS_CHECK_TABLE on each system table.

Throws:

java.sql.SQLException