Subject | Re: [Firebird-Architect] Re: Indexed Views |
---|---|
Author | Alexander Klenin |
Post date | 2004-12-23T06:05:27Z |
> > > > well, this gives some weight to a proposal to throw exception onSo, would not it be better for the engine to throw an exception in that case?
> > > > SELECT from procedures without SUSPEND -- for I have made such mistake
> > > > more than once.
> > >
> > > EXECUTE BLOCK with outputs semantically fully equal to
> > > SELECT * FROM stored procedure
> > And will silently return empty "resultset" if I forget to add SUSPEND?
>
> Yes, exactly.
That is, SELECT * FROM myproc
where myproc does not contain a SUSPEND