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

[Claudio V. C. <cv...@us...>]

Holger Klemt wrote:
> here is also a way that always crashes the server
> (was lready reported in firebird support list)
>
> just run the following procedure:
>
> CREATE PROCEDURE SP
> RETURNS (
>     RET VARCHAR(100))
> AS
> declare variable sql varchar(200);
> begin
>   sql=null;
>   execute statement sql into ret;
>   suspend;
> end
>
> I use Firebird 1.5.1.4481 on Windows

It seems it has to be put in the tracker, so it's documented and marked as
fixed in the HEAD:

F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>isql -z
ISQL Version: WI-T2.0.0.8308 Firebird 2.0 UNSTABLE
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'holger';
SQL> set term ^;
SQL> CREATE PROCEDURE SP
CON> RETURNS (
CON>     RET VARCHAR(100))
CON> AS
CON> declare variable sql varchar(200);
CON> begin
CON>   sql=null;
CON>   execute statement sql into ret;
CON>   suspend;
CON> end
CON> ^
SQL> select * from sp^

RET
==================================================================
Statement failed, SQLCODE = -904
Invalid argument in EXECUTE STATEMENT - cannot convert to string
-At procedure 'SP'
SQL> ^Z

I did exactly what you suggested.

C.