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

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

Alessandro Petrelli wrote:

>sorry but something's gone wrong with copy&paste, should be:
>
>EXECUTE STATEMENT 'select count(*)  from ' || :TABLE_NAME INTO :MYCOUNT;
>  
>

Guys, PLEASE - give exact details!
In  current HEAD:

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> select * from CRASH_ENGINE(NULL)^

     MYCOUNT
============
Statement failed, SQLCODE = -904

Invalid argument in EXECUTE STATEMENT - cannot convert to string
-At procedure 'CRASH_ENGINE'
SQL> select * from CRASH_ENGINE('rdb$database')^
SQL> execute procedure CRASH_ENGINE^
Statement failed, SQLCODE = -902

Dynamic SQL Error
-parameter mismatch for procedure CRASH_ENGINE
SQL>

WHAT parameter should be passed? Yopu see passing NULL makes no harm, 
call w/o parameter impossible.
WHAT engine version? I check against HEAD...

A.