You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2007/04/18 18:50:33 UTC
svn commit: r530087 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java
Author: kmarsden
Date: Wed Apr 18 09:50:31 2007
New Revision: 530087
URL: http://svn.apache.org/viewvc?view=rev&rev=530087
Log:
DERBY-2560 Missing asserts in ProcedureInTriggerTest
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java?view=diff&rev=530087&r1=530086&r2=530087
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java Wed Apr 18 09:50:31 2007
@@ -275,6 +275,7 @@
rs = s.executeQuery("select * from t1");
expectedRows = new String [][]
{{"5","two "},{"6","four "},{"8","eight "}};
+ JDBC.assertFullResultSet(rs, expectedRows);
s.execute("drop trigger delete_trig");
//--- Procedures with schema name
s.execute("create trigger call_proc_in_default_schema AFTER insert on t2 for each STATEMENT call APP.proc_no_sql()");
@@ -441,6 +442,7 @@
//--- check delete failed
rs = s.executeQuery("select * from t1");
expectedRows = new String[][] { {"5","two"},{"6","four"},{"8","eight"}};
+ JDBC.assertFullResultSet(rs, expectedRows);
//--- check trigger is not created
rs = s.executeQuery("select count(*) from SYS.SYSTRIGGERS where triggername='TEST_TRIG'");
JDBC.assertFullResultSet(rs, new String[][] {{"0"}});