"Geoff Worboys" <geoff@...> wrote:

>
> Personnally I would also like an exception to be thrown when
> a procedure is called with an incompatible method. This way,
> as a developer, I get told when I've stuffed up. Possibly
> this is undesireable for backwards compatibility reasons.

Now we have:

CREATE PROCEDURE P RETURNS (X INT)
BEGIN
X = 0;
SUSPEND;
END

And by design it has two compatible execution methods. And we must preserve
it, not because it's a legacy stuff, but because it's a useful feature,
IMHO.


Dmitry