db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ma...@apache.org
Subject svn commit: r1617641 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java
Date Wed, 13 Aug 2014 00:42:04 GMT
Author: mamta
Date: Wed Aug 13 00:42:04 2014
New Revision: 1617641

URL: http://svn.apache.org/r1617641
Log:
DERBY-6684(Failure in testDERBY5120NumRowsInSydependsForTrigger when upgrading from 10.11.1.0
to trunk)
We ran into DERBY-6684 after the fix for DERBY-2041 went into 10.11
The failure is the expected behavior since when dropping a table,
we should detect any dependent triggers defined on other tables
and drop table should fail if such dependencies exist. To fix the
test failure, we just need to switch the order of drop table
DERBY-2041(Trigger should register a dependency on tables and columns used in its body)
Drop ATDC_TAB1 before ATDC_BKUP1 because ATDC_TAB1 has a trigger
on it which references ATDC_BKUP1. If we try dropping ATDC_BKUP1
without first dropping ATDC_TAB1, there will be an error message
that trigger ATDC_TAB1_TRG1 depends on ATDC_BKUP1


Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java?rev=1617641&r1=1617640&r2=1617641&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/BasicSetup.java
Wed Aug 13 00:42:04 2014
@@ -401,8 +401,21 @@ public class BasicSetup extends UpgradeC
         Statement s = createStatement();
         boolean modeDb2SqlOptional = oldAtLeast(10, 3);
 
-        dropTable("ATDC_BKUP1");
+        //DERBY-6684(Failure in testDERBY5120NumRowsInSydependsForTrigger when 
+        // upgrading from 10.11.1.0 to trunk)
+        //We ran into DERBY-6684 after the fix for DERBY-2041 went into 10.11
+        //The failure is the expected behavior since when dropping a table,
+        // we should detect any dependent triggers defined on other tables
+        // and drop table should fail if such dependencies exist. To fix the
+        // test failure, we just need to switch the order of drop table
+        //DERBY-2041(Trigger should register a dependency on tables and 
+        // columns used in its body)
+        //Drop ATDC_TAB1 before ATDC_BKUP1 because ATDC_TAB1 has a trigger
+        // on it which references ATDC_BKUP1. If we try dropping ATDC_BKUP1
+        // without first dropping ATDC_TAB1, there will be an error message
+        // that trigger ATDC_TAB1_TRG1 depends on ATDC_BKUP1
         dropTable("ATDC_TAB1");
+        dropTable("ATDC_BKUP1");
         s.execute("create table ATDC_TAB1(c11 int, c12 int)");
         s.execute("insert into ATDC_TAB1 values (1,11)");
         s.execute("create table ATDC_BKUP1(c111 int, c112 int)");



Mime
View raw message