This test has a case where it needs to count the number of executions of a NO SQL procedure in a trigger.
This was tested with a System.out.println statement in the old SQL test, e.g.
public static void zeroArg()
The sql is a follows:
create procedure proc_no_sql() parameter style java language java NO SQL external name 'org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest.zeroArg
create trigger after_stmt_trig_no_sql AFTER insert on t2 for each STATEMENT call proc_no_sql()
insert into t2 values (1,2), (2,4);
I want to check that zeroArg was called only once but can't figure out how to do it without adding sql to insert into a table. Any thoughts on this?