Subject | Re: RFC: Please unify stored procedure execution |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-12-21T16:41:29Z |
> Care to show us that example?Vlad posted example IF (1=0) THEN SUSPEND;. No real example was
>
> (as some seem to think that the existence of output parameters makes
> it selectable ;-)
showed, but let me suggest following:
CREATE PROCEDURE test(a INTEGER) RETURNS (b INTEGER)
AS BEGIN
b = 2;
IF (0=1) THEN
SUSPEND;
b = 3;
END
If this condition never happens, then we have pretty legitimate
executable procedure with SUSPEND inside and when it is called with
SELECT * FROM it will return empty result set.
But again, this is far beyond my knowledge of BLR and must be answered
by core engine developers.
Roman