[Firebird-test] Bug in DSQL parameter?

[<fe...@gm...>]

Hi people!

Look this (Test in FB 2.0 RC4 with IBExpert):
------------------------------------------------------------------------------------------
CREATE TABLE TEST (MYDATE DATE NOT NULL PRIMARY KEY);
COMMIT;

INSERT INTO TEST VALUES (CURRENT_DATE);
INSERT INTO TEST VALUES (CURRENT_DATE + 1);
INSERT INTO TEST VALUES (CURRENT_DATE + 2);
INSERT INTO TEST VALUES (CURRENT_DATE + 3);
COMMIT;

-- This expression fails
SELECT * FROM TEST WHERE MYDATE + CAST(:days AS INTEGER) >= :dateparam;
--Error:
--Dynamic SQL Error.
--SQL error code = -804.
--Data type unknown.

--But in this is okay
SELECT * FROM TEST WHERE MYDATE + 5 >= :dateparam;
------------------------------------------------------------------------------------------
Is a bug???


Another question:

In FB 1.5 and oldest this query fails:
SELECT 1 FROM RDB$DATABASE :myparam IS NULL;

With the feature in FB 2.0 (Bug fix #1371274) this situation can be
corrected thus:
SELECT 1 FROM RDB$DATABASE CAST(:myparam AS INTEGER) IS NULL;

But I think that in this situation is not necessary for engine know a
datatype, because the parameter "myparam" is verified with null state.
Is not a bug, right? But a feature?

Thanks
Maycon Ferraça - Brazil

PS.:
(1) Sorry if this wrong place for this message.
(2) Sorry for my bad bad english... :S