Re: [Firebird-devel] Execute statement, engine crash test-case

[Alex P. <pe...@in...>]

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.