Subject Re: RFC: Please unify stored procedure execution
Author Roman Rokytskyy
> Care to show us that example?
>
> (as some seem to think that the existence of output parameters makes
> it selectable ;-)

Vlad posted example IF (1=0) THEN SUSPEND;. No real example was
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