Bugs item #1898473, was opened at 2008-02-21 06:48
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1898473&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: None
Group: None
>Status: Closed
>Resolution: Works For Me
Priority: 5
Private: No
Submitted By: David Wung (fivecolor)
Assigned to: Nobody/Anonymous (nobody)
Summary: call procedure including while

Initial Comment:
When calling the procedure including 'while', mserver seems to be in die 
circle, unless interrupt it.
Following query is my test script in mclient:

create table t1(a int);
create table t2(b int);
create procedure p1(a int) while (a>2) do select * into t1 from t2 ;end while;
call p1(1); -- OK
call p1(3); -- waiting all the times

Thanks.

----------------------------------------------------------------------

Comment By: Niels Nes (nielsnes)
Date: 2008-02-21 08:12

Message:
Logged In: YES 
user_id=43556
Originator: NO

isn't this what you ask the server for, ie while (a>2) never ends. Once
your code assigns a value <= 2 to a it stops. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1898473&group_id=56967

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to