FB3 vs FB2.5. Different metadata for UDF return argument
--------------------------------------------------------
Key: CORE-4237
URL: http://tracker.firebirdsql.org/browse/CORE-4237
Project: Firebird Core
Issue Type: Bug
Components: Engine, UDF
Affects Versions: 3.0 Alpha 1
Environment: WI-T3.0.0.30653 Firebird 3.0 Alpha 1
Reporter: Kovalenko Dmitry
[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 that FB3 works incorrectly.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
