Subject | bug in Firebird (with server crash!) |
---|---|
Author | hklemt@yahoo.de |
Post date | 2004-09-14T07:12:58Z |
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
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