org.apache.derbyTesting.functionTests.tests.lang

Class SynonymTest

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

All Implemented Interfaces:

junit.framework.Test

public class SynonymTest
extends BaseJDBCTestCase

Synonym testing using junit

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
SynonymTest(java.lang.String name) Basic constructor.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite() Create a suite of tests.
void	testMetaDataCallOnSynonymsDERBY5244() DERBY-5244 DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM.
void	testSynonymsForTablesWithDoubleQuotes() Verify the fix for DERBY-5168.
void	testSynonymsInSearchedDeleteDERBY4110() Test that synonyms are dereferenced properly for a searched DELETE.
void	testViewDependency() The test makes sure that we correctly throw dependency exception when user requests to drop a synonym which has dependent objects on it.

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

SynonymTest

public SynonymTest(java.lang.String name)

Basic constructor.

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests.

testViewDependency

public void testViewDependency()
                        throws java.sql.SQLException

The test makes sure that we correctly throw dependency exception when user requests to drop a synonym which has dependent objects on it. Once the dependency is removed, we should be able to drop the synonym.

Throws:

java.sql.SQLException

testMetaDataCallOnSynonymsDERBY5244

public void testMetaDataCallOnSynonymsDERBY5244()
                                         throws java.sql.SQLException

DERBY-5244 DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM. This is because for synonyms, we do not add any rows in SYSCOLUMNS. But the metadata query for DatabaseMetaData.getColumns() looks at SYSCOLUMNS to get the resultset. Views and Tables do not have problems because we do keep their columns information in SYSCOLUMNS. Test DatabaseMetaData.getColumns call on synonyms This test confirms the behavior noticed in DERBY-5244.

Throws:

java.sql.SQLException

testSynonymsInSearchedDeleteDERBY4110

public void testSynonymsInSearchedDeleteDERBY4110()
                                           throws java.sql.SQLException

Test that synonyms are dereferenced properly for a searched DELETE. This test verifies that DERBY-4110 is fixed.

Throws:

java.sql.SQLException

testSynonymsForTablesWithDoubleQuotes

public void testSynonymsForTablesWithDoubleQuotes()
                                           throws java.sql.SQLException

Verify the fix for DERBY-5168. SynonymAliasInfo.toString() used to return a value with incorrect syntax if the synonym referred to a table that had a double quote character either in its name or in the schema name.

Throws:

java.sql.SQLException