Bugs item #1898473, was opened at 2008-02-21 14:48 Message generated for change (Comment added) made by fivecolor 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: David Wung (fivecolor) Date: 2008-02-22 10:09 Message: Logged In: YES user_id=2013222 Originator: YES Yes, you are right. Furthermore, does procedure sustain ‘begin & end’? If it can, what syntax is it? ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-02-21 16: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
