db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r757287 - /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java
Date Mon, 23 Mar 2009 00:06:08 GMT
Author: kmarsden
Date: Mon Mar 23 00:06:08 2009
New Revision: 757287

URL: http://svn.apache.org/viewvc?rev=757287&view=rev
Log:
DERBY-4095 Trigger in fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet
not open during VTIResultSet.getNextRowCore()

fix typo in test. Change --DERBY-PROEPERTIES to --DERBY-PROPERTIES. Neither the typo nor the
correction of it affects the efficacy of the test. 


Modified:
    db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java

Modified: db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java?rev=757287&r1=757286&r2=757287&view=diff
==============================================================================
--- db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java
(original)
+++ db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/TriggerTest.java
Mon Mar 23 00:06:08 2009
@@ -1136,7 +1136,7 @@
         s.executeUpdate("CREATE TABLE APP.NAMES(ID INT, NAME VARCHAR(30))");
 
         
-        s.executeUpdate("CREATE TRIGGER  APP.MYTRIG AFTER DELETE ON APP.TAB REFERENCING OLD_TABLE
AS OLDROWS FOR EACH STATEMENT INSERT INTO APP.LOG(i,name,deltime) SELECT OLDROWS.I, NAMES.NAME,
CURRENT_TIMESTAMP FROM --DERBY-PROPERTIES joinOrder=FIXED\n NAMES, OLDROWS --DERBY-PROEPERTIES
joinStrategy = NESTEDLOOP\n WHERE (OLDROWS.i = NAMES.ID) AND (1 = 1)");
+        s.executeUpdate("CREATE TRIGGER  APP.MYTRIG AFTER DELETE ON APP.TAB REFERENCING OLD_TABLE
AS OLDROWS FOR EACH STATEMENT INSERT INTO APP.LOG(i,name,deltime) SELECT OLDROWS.I, NAMES.NAME,
CURRENT_TIMESTAMP FROM --DERBY-PROPERTIES joinOrder=FIXED\n NAMES, OLDROWS --DERBY-PROPERTIES
joinStrategy = NESTEDLOOP\n WHERE (OLDROWS.i = NAMES.ID) AND (1 = 1)");
         
         s.executeUpdate("insert into APP.tab values(1)");
         s.executeUpdate("insert into APP.tab values(2)");



Mime
View raw message