Update of /cvsroot/monetdb/sql/src/test/Dependencies
In directory sc8-pr-cvs16:/tmp/cvs-serv8185
Added Files:
dependency-loop.sql
Log Message:
Added file for bug report [ 1714809 ] Infinite loop....
--- NEW FILE: dependency-loop.sql ---
-- [ 1714809 ] Infinite loop....
create table t1Infi(id int, name varchar(1024), age int);
create table t2Infi(id int, age int);
create PROCEDURE p1(id int, age int)
BEGIN
insert into t2Infi values(id, age);
END;
create PROCEDURE p1()
BEGIN
declare id int, age int;
set id = 1;
set age = 23;
call p1(id, age);
END;
create trigger test_0 after insert on t2Infi
BEGIN ATOMIC
insert into t1Infi values(1, 'monetdb', 24);
call p1();
END;
drop trigger test_0;
drop procedure p1;
drop table t1Infi;
drop table t2Infi;
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
