Missing asserts in ProcedureInTriggerTest
-----------------------------------------

                 Key: DERBY-2560
                 URL: https://issues.apache.org/jira/browse/DERBY-2560
             Project: Derby
          Issue Type: Bug
          Components: Test
    Affects Versions: 10.3.0.0
            Reporter: Knut Anders Hatlen


ProcedureInTriggerTest sometimes executes queries without checking the results. 
The comments indicate that the results should have been checked.

line 258-259 and line 263-264:
       //--- Check that insert successful and trigger fired. 
       rs = s.executeQuery("select * from t1");

line 408-410:
         //--- check delete failed
         rs = s.executeQuery("select * from t1");
         expectedRows = new String[][] { 
{"5","two"},{"6","four"},{"8","eight"}};

line 421-422:
         //--- check trigger is not dropped
         rs = s.executeQuery("select count(*) from SYS.SYSTRIGGERS where 
triggername='TEST_TRIG'");

line 431-432:
         // -- check index is not created
         rs = s.executeQuery("select count(*) from SYS.SYSCONGLOMERATES where 
CONGLOMERATENAME='IX' and ISINDEX=1");

line 438-440:
         // -- check delete failed
         rs = s.executeQuery("select * from t1");
         expectedRows = new String[][] { 
{"5","two"},{"6","four"},{"8","eight"}};

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to