Bugs item #1714809, was opened at 2007-05-08 11:17
Message generated for change (Comment added) made by mlkersten
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1714809&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: Infinite loop....
Initial Comment:
Just run the example:
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
create PROCEDURE p1(id int, age int)
BEGIN
insert into t2 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 t2
BEGIN ATOMIC
insert into t1 values(1, 'monetdb', 24);
call p1();
END;
insert into t2 values(0, 24);
There is a infinite loop due the call of p1(). The infinite loops created by
triggers (an update operation from one trigger which fires another trigger)
were killed. However, when the update comes from a procedure the infinite loop
is not avoided.
Regards,
Romulo
----------------------------------------------------------------------
>Comment By: Martin Kersten (mlkersten)
Date: 2007-05-08 17:04
Message:
Logged In: YES
user_id=490798
Originator: NO
A defense line is to call language.assertSpace(N)
where the stack space is limited to N*variables in current block.
This could could be included in the start of a (recursive)
function body, or those that call at least one other SQL function/proc.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1714809&group_id=56967
-------------------------------------------------------------------------
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-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
