Hi
[TEST UDF]
DECLARE EXTERNAL FUNCTION UDF_TEST2 RETURNS BLOB ENTRY_POINT 'IB_UDF_abs'
MODULE_NAME 'ib_udf';
+++++++++++++++++++++++++++++++++++++++++++++++
[FB2.5]
ISQL> show function UDF_TEST2;
Function UDF_TEST2:
Function library is ib_udf
Entry point is IB_UDF_abs
Returns BLOB
-----------
select * from rdb$functions x where x.rdb$function_name='UDF_TEST2'
RDB$FUNCTION_NAME: UDF_TEST2
RDB$FUNCTION_TYPE: <null>
RDB$QUERY_NAME: <null>
RDB$DESCRIPTION: <null>
RDB$MODULE_NAME: ib_udf
RDB$ENTRYPOINT: IB_UDF_abs
RDB$RETURN_ARGUMENT: 1
RDB$SYSTEM_FLAG: 0
-----------
select * from rdb$function_arguments x where x.rdb$function_name='UDF_TEST2'
RDB$FUNCTION_NAME: UDF_TEST2
RDB$ARGUMENT_POSITION: 1
RDB$MECHANISM: 3
RDB$FIELD_TYPE: 261
RDB$FIELD_SCALE: 0
RDB$FIELD_LENGTH: 8
RDB$FIELD_SUB_TYPE: 0
RDB$CHARACTER_SET_ID: <null>
RDB$FIELD_PRECISION: <null>
RDB$CHARACTER_LENGTH: <null>
+++++++++++++++++++++++++++++++++++++++++++++++
[FB3]
ISQL> show FUNCTION UDF_TEST2;
Function UDF_TEST2:
Function library is ib_udf
Entry point is IB_UDF_abs
Argument 0: BLOB
-----------
select * from rdb$functions x where x.rdb$function_name='UDF_TEST2'
RDB$FUNCTION_NAME: UDF_TEST2
RDB$FUNCTION_TYPE: <null>
RDB$QUERY_NAME: <null>
RDB$DESCRIPTION: <null>
RDB$MODULE_NAME: ib_udf
RDB$ENTRYPOINT: IB_UDF_abs
RDB$RETURN_ARGUMENT: 1
RDB$SYSTEM_FLAG: 0
RDB$ENGINE_NAME: <null>
RDB$PACKAGE_NAME: <null>
RDB$PRIVATE_FLAG: <null>
RDB$FUNCTION_SOURCE: <null>
RDB$FUNCTION_ID: 2749
RDB$FUNCTION_BLR: <null>
RDB$VALID_BLR: 1
RDB$DEBUG_INFO: <null>
RDB$SECURITY_CLASS: SQL$11302
RDB$OWNER_NAME: GAMER
RDB$LEGACY_FLAG: 1
RDB$DETERMINISTIC_FLAG: 0
-----------
select * from rdb$function_arguments x where x.rdb$function_name='UDF_TEST2'
RDB$FUNCTION_NAME: UDF_TEST2
RDB$ARGUMENT_POSITION: 0
RDB$MECHANISM: 3
RDB$FIELD_TYPE: 261
RDB$FIELD_SCALE: 0
RDB$FIELD_LENGTH: 0
RDB$FIELD_SUB_TYPE: 0
RDB$CHARACTER_SET_ID: <null>
RDB$FIELD_PRECISION: <null>
RDB$CHARACTER_LENGTH: <null>
RDB$PACKAGE_NAME: <null>
RDB$ARGUMENT_NAME: <null>
RDB$FIELD_SOURCE: <null>
RDB$DEFAULT_VALUE: <null>
RDB$DEFAULT_SOURCE: <null>
RDB$COLLATION_ID: <null>
RDB$NULL_FLAG: <null>
RDB$ARGUMENT_MECHANISM: 0
RDB$FIELD_NAME: <null>
RDB$RELATION_NAME: <null>
RDB$SYSTEM_FLAG: 0
RDB$DESCRIPTION: <null>
+++++++++++++++++++++++++++++++++++++++++++++++
It seems, FB3 works incorrectly. I'm right?
Dmitry Kovalenko
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
