Subject | "Select First" bug report |
---|---|
Author | precari0 |
Post date | 2004-11-11T14:11:22Z |
Hi all,
recently I came across a bug in the FB engine.
You can reproduce it by running the following (tested on FB 1.0.3 and
1.5.0):
select first (cast(null as integer)) rdb$relation_id
from rdb$database
The server crashes.
Another not so obvious variation is this:
CREATE PROCEDURE CRASH_TEST(
NUM1 INTEGER,
NUM2 INTEGER)
RETURNS (
RDB$RELATION_ID SMALLINT)
AS
BEGIN
FOR select first (:num1 * :num2) rdb$relation_id
from rdb$database
INTO :RDB$RELATION_ID DO
BEGIN
SUSPEND;
END
END
execute procedure crash_test(1, null);
Can someone test this against fb 1.5.2rc1?
If it is found there too but the fix can't make it to the final
release, I
think this should be documented on the release notes on a very big-
bold-red
font.
Cheers,
Dog
--
Douglas Heron Tosi
CTVoicer Computer Telephony ltda
mailto : douglas em ctvoicer . com . br
41 3224766
41 99219950
recently I came across a bug in the FB engine.
You can reproduce it by running the following (tested on FB 1.0.3 and
1.5.0):
select first (cast(null as integer)) rdb$relation_id
from rdb$database
The server crashes.
Another not so obvious variation is this:
CREATE PROCEDURE CRASH_TEST(
NUM1 INTEGER,
NUM2 INTEGER)
RETURNS (
RDB$RELATION_ID SMALLINT)
AS
BEGIN
FOR select first (:num1 * :num2) rdb$relation_id
from rdb$database
INTO :RDB$RELATION_ID DO
BEGIN
SUSPEND;
END
END
execute procedure crash_test(1, null);
Can someone test this against fb 1.5.2rc1?
If it is found there too but the fix can't make it to the final
release, I
think this should be documented on the release notes on a very big-
bold-red
font.
Cheers,
Dog
--
Douglas Heron Tosi
CTVoicer Computer Telephony ltda
mailto : douglas em ctvoicer . com . br
41 3224766
41 99219950