Subject "Select First" bug report
Author precari0
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