> I've noticed that in Fb 3, the MECHANISM for procedure& function > parameters is set to "1", meaning "type of", even though you're using > raw datatypes. > > An implicit domain is created automagically in RDB$FIELDS, but I > think that the mechanism should be 0 then, don't you?
Test case: ;-) 1) Create the following SP in a FB 2.5 and 3.0 database SET TERM ^^ ; CREATE PROCEDURE P_1 ( MYID Integer) AS begin /* code */ end ^^ SET TERM ; ^^ 2) Execute the following query in both databases select * from rdb$procedure_parameters where rdb$procedure_name = 'P_1' and rdb$parameter_mechanism <> 0 In Firebird 2.5, you get an empty result set. In Firebird 3.0 you get one row. I guess it should be an empty result set in both cases (at least that's the behaviour in 2.5). Regards, Thomas ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
