TriggerTest (Apache Derby V10.10 Test Javadoc)

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

All Implemented Interfaces:

junit.framework.Test
```
public class TriggerTest
extends BaseJDBCTestCase
```
Test triggers.

Field Summary

Fields
Modifier and Type	Field and Description
`(package private) java.lang.StringBuffer`	`listOfCreatedTriggers`
`private static java.lang.ThreadLocal`	`TRIGGER_INFO` Thread local that a trigger can access to allow recording information about the firing.

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors
Constructor and Description

TriggerTest(java.lang.String name)

Constructors
Constructor and Description
`TriggerTest(java.lang.String name)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private void`	`actionTypesCompareMainToAction(int actionCount, java.lang.String type)` Compare the contents of the main table to the action table.
`private void`	`actionTypesCompareMainToActionForUpdate(java.lang.String type, int id)` Compare the values for an update trigger.
`private void`	`actionTypesDeleteTest(java.lang.String type)` Test deletes with the specified types in the action statement.
`private void`	`actionTypesInsertTest(java.lang.String type)` Execute three insert statements.
`private void`	`actionTypesSetup(java.lang.String type)` Setup the tables and triggers for a single type for actionTypeTest
`private void`	`actionTypesUpdateTest(java.lang.String type)` Test updates of the specified types in the action statement.
`private void`	`actionTypeTest(java.lang.String type)` Test that the action statement of a trigger can work with a specific datatype.
`private int`	`assertFiringOrder(java.lang.String iud, int modifiedRowCount)` Look at the ordered information in the thread local and ensure it reflects correct sequenceing of triggers created in testFiringOrder.
`private int`	`assertFiringOrder(java.lang.String iud, int modifiedRowCount, boolean noAfter)`
`private int[]`	`createRandomTriggers()`
`static void`	`derby4610proc(java.lang.String str)` Procedure that does nothing.
`static java.lang.Object`	`getRandomValue(java.util.Random r, int jdbcType, int precision)` Generate a random object (never null) for a given JDBC type.
`protected void`	`initializeConnection(java.sql.Connection conn)` Allow a sub-class to initialize a connection to provide consistent connection state for its tests.
`static void`	`logTriggerInfo(java.lang.String info)` Record the trigger information in the thread local.
`private int`	`numberOfInvalidStatementsInSysstatements(java.sql.Statement st)`
`private int`	`numberOfRowsInSysstatements(java.sql.Statement st)`
`private int`	`numberOfValidStatementsInSysstatements(java.sql.Statement st)`
`private static byte[]`	`randomBinary(java.util.Random r, int len)`
`private static java.lang.String`	`randomString(java.util.Random r, int len)`
`static void`	`setRandomValue(java.util.Random r, java.sql.PreparedStatement ps, int column, int jdbcType, int precision)`
`protected void`	`setUp()`
`static junit.framework.Test`	`suite()` Run only in embedded as TRIGGERs are server side logic.
`protected void`	`tearDown()` Tear down this fixture, sub-classes should call super.tearDown().
`void`	`testAlerColumnLength()` Altering the column length should regenerate the trigger action plan which is saved in SYSSTATEMENTS.
`void`	`testBlobInTriggerTable()` Test for DERBY-3238 trigger fails with IOException if triggering table has large lob.
`private void`	`testBlobInTriggerTable(int blobSize)` Create a table with after update trigger on non-lob column.
`void`	`testClobInTriggerTable()` Test for DERBY-3238 trigger fails with IOException if triggering table has large lob.
`private void`	`testClobInTriggerTable(int clobSize)` Create a table with after update trigger on non-lob column.
`void`	`testDerby4095NewTriggerRows()` Test that a nested loop join that accesses the TriggerNewTransitionRowsVTI can reopen the ResultSet properly when it re-executes.
`void`	`testDerby4095OldTriggerRows()` Test that a nested loop join that accesses the TriggerOldTransitionRowsVTI can reopen the ResultSet properly when it re-executes.
`void`	`testDerby4610WrongDataType()` Regression test case for DERBY-4610, where a DELETE statement failed because a trigger used the wrong meta-data and mixed up the data types.
`void`	`testDERBY5121()`
`void`	`testDerby5578InvalidateAllStatementsProc()` Test that invalidating stored statements marks the statement invalid in SYS.SYSSTATEMENTS.
`void`	`testDerby6348()`
`void`	`testDerby6351TransitionTableCorrelation()` Regression test case for DERBY-6351, where CREATE TRIGGER would fail with a syntax error if the triggered SQL statement referenced a transition table using a correlation name, and that correlation name was equal to the transition table name.
`void`	`testDerby6357TempTable()` Verify that CREATE TRIGGER fails if a temporary table is referenced.
`void`	`testDerby6371DropColumn()` Verify the fix for DERBY-6371.
`void`	`testDerby6383StatementTriggerBugTst1()` DERBY-6383(Update trigger defined on one column fires on update of other columns).
`void`	`testDerby6383StatementTriggerBugTst2()` DERBY-6383(Update trigger defined on one column fires on update of other columns).
`void`	`testFiringConstraintOrder()` Test that a order of firing is before triggers, constraint checking and after triggers.
`void`	`testFiringOrder()` Test the firing order of triggers.
`void`	`testNPEinTriggerFire()` Test for DERBY-3718 NPE when a trigger is fired
`void`	`testReadRequiredColumnsOnlyFromTriggerTable()`
`void`	`testTypesInActionStatement()` Test that the action statement of a trigger can work with all datatypes.
`void`	`testUpdateTriggerOnClobColumn()`

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, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, 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, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - TRIGGER_INFO
```
private static java.lang.ThreadLocal TRIGGER_INFO
```
    Thread local that a trigger can access to allow recording information about the firing.
  - listOfCreatedTriggers
```
java.lang.StringBuffer listOfCreatedTriggers
```
- Constructor Detail
  - TriggerTest
```
public TriggerTest(java.lang.String name)
```
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Run only in embedded as TRIGGERs are server side logic. Also the use of a ThreadLocal to check state requires embedded.
  - initializeConnection
```
protected void initializeConnection(java.sql.Connection conn)
                             throws java.sql.SQLException
```
    Description copied from class: BaseJDBCTestCase
    Allow a sub-class to initialize a connection to provide consistent connection state for its tests. Called once for each time these method calls open a connection:
    - getConnection()
    - openDefaultConnection()
    - openConnection(database)
    - getDefaultConnection(String connAttrs)
    Default action is to not modify the connection's state from the initialization provided by the data source.
    Overrides:
    
    initializeConnection in class BaseJDBCTestCase
    
    Parameters:
    
    conn - Connection to be intialized
    
    Throws:
    
    java.sql.SQLException - Error setting the initial state.
  - setUp
```
protected void setUp()
              throws java.lang.Exception
```
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.lang.Exception
  - tearDown
```
protected void tearDown()
                 throws java.lang.Exception
```
    Description copied from class: BaseJDBCTestCase
    
    Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.
    
    Overrides:
    
    tearDown in class BaseJDBCTestCase
    
    Throws:
    
    java.lang.Exception
  - testDerby6383StatementTriggerBugTst1
```
public void testDerby6383StatementTriggerBugTst1()
                                          throws java.sql.SQLException
```
    DERBY-6383(Update trigger defined on one column fires on update of other columns). This regression is caused by DERBY-4874(Trigger does not recognize new size of VARCHAR column expanded with ALTER TABLE. It fails with ERROR 22001: A truncation error was encountered trying to shrink VARCHAR) The regression is for Statement level triggers. The trigger gets fired for any column update rather than just the column specified in the UPDATE of column clause. Following test confirms that fix for DERBY-6383 fixes the issue.
    
    Throws:
    
    java.sql.SQLException
  - testDerby6383StatementTriggerBugTst2
```
public void testDerby6383StatementTriggerBugTst2()
                                          throws java.sql.SQLException
```
    DERBY-6383(Update trigger defined on one column fires on update of other columns). This regression is caused by DERBY-4874(Trigger does not recognize new size of VARCHAR column expanded with ALTER TABLE. It fails with ERROR 22001: A truncation error was encountered trying to shrink VARCHAR) After an update statement level trigger is defined at the table level, when a new column is added, trigger should fire on update of that newly added column
    
    Throws:
    
    java.sql.SQLException
  - testDerby5578InvalidateAllStatementsProc
```
public void testDerby5578InvalidateAllStatementsProc()
                                              throws java.sql.SQLException
```
    Test that invalidating stored statements marks the statement invalid in SYS.SYSSTATEMENTS. And when one of those invalid statements is executed next, it is recompiled and as part of that process, it gets marked valid in SYS.SYSSTATEMENTS.
    
    Throws:
    
    java.sql.SQLException
  - numberOfInvalidStatementsInSysstatements
```
private int numberOfInvalidStatementsInSysstatements(java.sql.Statement st)
                                              throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - numberOfValidStatementsInSysstatements
```
private int numberOfValidStatementsInSysstatements(java.sql.Statement st)
                                            throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - numberOfRowsInSysstatements
```
private int numberOfRowsInSysstatements(java.sql.Statement st)
                                 throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testAlerColumnLength
```
public void testAlerColumnLength()
                          throws java.sql.SQLException
```
    Altering the column length should regenerate the trigger action plan which is saved in SYSSTATEMENTS. DERBY-4874
    
    Throws:
    
    java.sql.SQLException
  - testFiringOrder
```
public void testFiringOrder()
                     throws java.sql.SQLException
```
    Test the firing order of triggers. Should be: Before operations after operations For multiple triggers within the same group (before or after) firing order is determined by create order.
    
    Throws:
    
    java.sql.SQLException
  - createRandomTriggers
```
private int[] createRandomTriggers()
                            throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testFiringConstraintOrder
```
public void testFiringConstraintOrder()
                               throws java.sql.SQLException
```
    Test that a order of firing is before triggers, constraint checking and after triggers.
    
    Throws:
    
    java.sql.SQLException
  - assertFiringOrder
```
private int assertFiringOrder(java.lang.String iud,
                              int modifiedRowCount)
```
    Look at the ordered information in the thread local and ensure it reflects correct sequenceing of triggers created in testFiringOrder.
    
    Parameters:
    
    iud -
    
    Returns:
    
    the number of triggers checked
  - assertFiringOrder
```
private int assertFiringOrder(java.lang.String iud,
                              int modifiedRowCount,
                              boolean noAfter)
```
  - logTriggerInfo
```
public static void logTriggerInfo(java.lang.String info)
```
    Record the trigger information in the thread local. Called as a SQL procedure.
    
    Parameters:
    
    info - trigger information
  - testNPEinTriggerFire
```
public void testNPEinTriggerFire()
                          throws java.sql.SQLException
```
    Test for DERBY-3718 NPE when a trigger is fired
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testReadRequiredColumnsOnlyFromTriggerTable
```
public void testReadRequiredColumnsOnlyFromTriggerTable()
                                                 throws java.sql.SQLException,
                                                        java.io.IOException
```
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testDERBY5121
```
public void testDERBY5121()
                   throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testClobInTriggerTable
```
public void testClobInTriggerTable()
                            throws java.sql.SQLException,
                                   java.io.IOException
```
    Test for DERBY-3238 trigger fails with IOException if triggering table has large lob.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testClobInTriggerTable
```
private void testClobInTriggerTable(int clobSize)
                             throws java.sql.SQLException,
                                    java.io.IOException
```
    Create a table with after update trigger on non-lob column. Insert clob of size clobSize into table and perform update on str1 column to fire trigger. Helper method called from testClobInTriggerTable
    
    Parameters:
    
    clobSize - size of clob to test
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testBlobInTriggerTable
```
public void testBlobInTriggerTable()
                            throws java.sql.SQLException,
                                   java.io.IOException
```
    Test for DERBY-3238 trigger fails with IOException if triggering table has large lob.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testBlobInTriggerTable
```
private void testBlobInTriggerTable(int blobSize)
                             throws java.sql.SQLException,
                                    java.io.IOException
```
    Create a table with after update trigger on non-lob column. Insert two blobs of size blobSize into table and perform update on str1 column to fire trigger. Helper method called from testBlobInTriggerTable
    
    Parameters:
    
    blobSize - size of blob to test.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testUpdateTriggerOnClobColumn
```
public void testUpdateTriggerOnClobColumn()
                                   throws java.sql.SQLException,
                                          java.io.IOException
```
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testTypesInActionStatement
```
public void testTypesInActionStatement()
                                throws java.sql.SQLException,
                                       java.io.IOException
```
    Test that the action statement of a trigger can work with all datatypes.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypeTest
```
private void actionTypeTest(java.lang.String type)
                     throws java.sql.SQLException,
                            java.io.IOException
```
    Test that the action statement of a trigger can work with a specific datatype.
    
    Parameters:
    
    type - SQL type to be tested
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypesSetup
```
private void actionTypesSetup(java.lang.String type)
                       throws java.sql.SQLException
```
    Setup the tables and triggers for a single type for actionTypeTest
    
    Throws:
    
    java.sql.SQLException
  - actionTypesInsertTest
```
private void actionTypesInsertTest(java.lang.String type)
                            throws java.sql.SQLException,
                                   java.io.IOException
```
    Execute three insert statements. NULL as the value for the type one row insert with random value for the type three row insert with random values for the type Check that the data in the action table matches the main table (see the after insert trigger definitions).
    
    Parameters:
    
    type -
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypesUpdateTest
```
private void actionTypesUpdateTest(java.lang.String type)
                            throws java.sql.SQLException,
                                   java.io.IOException
```
    Test updates of the specified types in the action statement.
    
    Parameters:
    
    type -
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypesCompareMainToActionForUpdate
```
private void actionTypesCompareMainToActionForUpdate(java.lang.String type,
                                                     int id)
                                              throws java.sql.SQLException,
                                                     java.io.IOException
```
    Compare the values for an update trigger.
    
    Parameters:
    
    type -
    
    id -
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypesDeleteTest
```
private void actionTypesDeleteTest(java.lang.String type)
                            throws java.sql.SQLException,
                                   java.io.IOException
```
    Test deletes with the specified types in the action statement.
    
    Parameters:
    
    type -
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - actionTypesCompareMainToAction
```
private void actionTypesCompareMainToAction(int actionCount,
                                            java.lang.String type)
                                     throws java.sql.SQLException,
                                            java.io.IOException
```
    Compare the contents of the main table to the action table. See the trigger defintions for details.
    
    Parameters:
    
    actionCount -
    
    type -
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - setRandomValue
```
public static void setRandomValue(java.util.Random r,
                                  java.sql.PreparedStatement ps,
                                  int column,
                                  int jdbcType,
                                  int precision)
                           throws java.sql.SQLException,
                                  java.io.IOException
```
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - getRandomValue
```
public static java.lang.Object getRandomValue(java.util.Random r,
                                              int jdbcType,
                                              int precision)
                                       throws java.io.IOException
```
    Generate a random object (never null) for a given JDBC type. Object is suitable for PreparedStatement.setObject() either with or without passing in jdbcType to setObject.
    For character types a String object or a StringReaderWithLength is returned.
    For binary types a byte[] or an instance of InputStream is returned. If an inputstream is returned then it can only be read once and in.available() returns the total number of bytes available to read. For BLOB types a random value is returned up to either the passed in precision or 256k. This is to provide a general purpose value that can be more than a page.
    Caller should check the return type using instanceof and use setCharacterStream() for Reader objects and setBinaryStream for InputStreams. (work in progress)
    
    Throws:
    
    java.io.IOException
  - randomBinary
```
private static byte[] randomBinary(java.util.Random r,
                                   int len)
```
  - randomString
```
private static java.lang.String randomString(java.util.Random r,
                                             int len)
```
  - testDerby4095OldTriggerRows
```
public void testDerby4095OldTriggerRows()
                                 throws java.sql.SQLException
```
    Test that a nested loop join that accesses the TriggerOldTransitionRowsVTI can reopen the ResultSet properly when it re-executes.
    
    Throws:
    
    java.sql.SQLException
  - testDerby4095NewTriggerRows
```
public void testDerby4095NewTriggerRows()
                                 throws java.sql.SQLException
```
    Test that a nested loop join that accesses the TriggerNewTransitionRowsVTI can reopen the ResultSet properly when it re-executes.
    
    Throws:
    
    java.sql.SQLException
  - testDerby4610WrongDataType
```
public void testDerby4610WrongDataType()
                                throws java.sql.SQLException
```
    Regression test case for DERBY-4610, where a DELETE statement failed because a trigger used the wrong meta-data and mixed up the data types.
    
    Throws:
    
    java.sql.SQLException
  - derby4610proc
```
public static void derby4610proc(java.lang.String str)
```
    Procedure that does nothing. Called as a stored procedure in the regression test case for DERBY-4610.
  - testDerby6351TransitionTableCorrelation
```
public void testDerby6351TransitionTableCorrelation()
                                             throws java.sql.SQLException
```
    Regression test case for DERBY-6351, where CREATE TRIGGER would fail with a syntax error if the triggered SQL statement referenced a transition table using a correlation name, and that correlation name was equal to the transition table name.
    
    Throws:
    
    java.sql.SQLException
  - testDerby6357TempTable
```
public void testDerby6357TempTable()
                            throws java.sql.SQLException
```
    Verify that CREATE TRIGGER fails if a temporary table is referenced. Regression test case for DERBY-6357.
    
    Throws:
    
    java.sql.SQLException
  - testDerby6348
```
public void testDerby6348()
                   throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testDerby6371DropColumn
```
public void testDerby6371DropColumn()
                             throws java.sql.SQLException
```
    Verify the fix for DERBY-6371. The dependency checking done when dropping a column used the wrong compilation schema and sometimes incorrectly reported that a trigger depended on the column.
    
    Throws:
    
    java.sql.SQLException

Class TriggerTest

Field Summary

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

Constructor Summary

Method Summary

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

TRIGGER_INFO

listOfCreatedTriggers

Constructor Detail

TriggerTest

Method Detail

suite

initializeConnection

setUp

tearDown

testDerby6383StatementTriggerBugTst1

testDerby6383StatementTriggerBugTst2

testDerby5578InvalidateAllStatementsProc

numberOfInvalidStatementsInSysstatements

numberOfValidStatementsInSysstatements

numberOfRowsInSysstatements

testAlerColumnLength

testFiringOrder

createRandomTriggers

testFiringConstraintOrder

assertFiringOrder

assertFiringOrder

logTriggerInfo

testNPEinTriggerFire

testReadRequiredColumnsOnlyFromTriggerTable

testDERBY5121

testClobInTriggerTable

testClobInTriggerTable

testBlobInTriggerTable

testBlobInTriggerTable

testUpdateTriggerOnClobColumn

testTypesInActionStatement

actionTypeTest

actionTypesSetup

actionTypesInsertTest

actionTypesUpdateTest

actionTypesCompareMainToActionForUpdate

actionTypesDeleteTest

actionTypesCompareMainToAction

setRandomValue

getRandomValue

randomBinary

randomString

testDerby4095OldTriggerRows

testDerby4095NewTriggerRows

testDerby4610WrongDataType

derby4610proc

testDerby6351TransitionTableCorrelation

testDerby6357TempTable

testDerby6348

testDerby6371DropColumn