|
From: Alex P. <pe...@in...> - 2004-09-20 07:28:23
|
Alessandro Petrelli wrote:
>Hi everyone
>
>I know the following SP have no-sense, but instead of rejecting the query it
>crashes the engine.
>I'm using Fb 1.5.1 Classic under Windows XP SP 2.
>
>CREATE PROCEDURE CRASH_ENGINE (
> TABLE_NAME VARCHAR(100))
>RETURNS (
> MYCOUNT INTEGER)
>AS
>BEGIN
> EXECUTE STATEMENT 'select count from ' || :TABLE_NAME INTO :MYCOUNT;
>END
>
>Any idea?
>
>
>
Couldn't reproduce in HEAD. More details required. The behaviour is 'as
designed'.
SQL> set term ^;
SQL> CREATE PROCEDURE CRASH_ENGINE (
CON> TABLE_NAME VARCHAR(100))
CON> RETURNS (
CON> MYCOUNT INTEGER)
CON> AS
CON> BEGIN
CON> EXECUTE STATEMENT 'select count from ' || :TABLE_NAME INTO :MYCOUNT;
CON> END
CON> ^
SQL> commit^
SQL> set term ;^
SQL> select * from CRASH_ENGINE('rdb$databases');
MYCOUNT
============
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 15
-from
SQL>
Alex.
|