>>> 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). >> >> > Fixed.
Good, I will check it out later. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
