Subject Re: [Firebird-Architect] Re: Indexed Views
Author Alexander Klenin
> > > > well, this gives some weight to a proposal to throw exception on
> > > > 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.
So, would not it be better for the engine to throw an exception in that case?
That is, SELECT * FROM myproc
where myproc does not contain a SUSPEND