Subject bug in Firebird (with server crash!)
Author hklemt@yahoo.de
i use a lot of execute statements in differents ways, but the
following problem now came up the first time, but it is
simply reproducable:

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

what happens?

C:\Programme\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)

Guardian starting: C:\Programme\Firebird\Firebird_1_5\bin\fbserver.exe

i know that this can be avoided by using an if clause before i
execute the statement, but there should be other solutions in the
future.

it happend because i created a sql statement in runtime, and one of
the variables, that should be used for the result sql string, was
null and so the result was also null. I never read about this bug
before, perhaps it is not new, but i think it should handle it like
any other invalid sql statement without a server crash.

I use Firebird 1.5.1.4481 on Windows

Best Regards

Holger Klemt


HK-Software Roadshow 2004 in Germany: Vom Daten-Chaos zur
Information, Datenbankstrategien für Ihr Unternehmen
Teilnahme kostenlos, Termine, Orte und Anmeldung www.h-k.de

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Huntestrasse 15 - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400