Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 80159 invoked from network); 18 Apr 2007 16:50:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Apr 2007 16:50:54 -0000 Received: (qmail 91443 invoked by uid 500); 18 Apr 2007 16:51:00 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 91380 invoked by uid 500); 18 Apr 2007 16:51:00 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 91369 invoked by uid 99); 18 Apr 2007 16:51:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Apr 2007 09:51:00 -0700 X-ASF-Spam-Status: No, hits=-99.5 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Apr 2007 09:50:53 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 7B1981A9838; Wed, 18 Apr 2007 09:50:33 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r530087 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ProcedureInTriggerTest.java Date: Wed, 18 Apr 2007 16:50:33 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20070418165033.7B1981A9838@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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"}});