[FB4] Description of RDB$FUNCTION_ARGUMENTS::RDB$MECHANISM

Question

[FB4] Description of RDB$FUNCTION_ARGUMENTS::RDB$MECHANISM

dmitry-lipetsk opened this issue 2 years ago · 6 comments

dmitry-lipetsk commented 2 years ago

This column can also contain the following values:

4 for SCALAR_ARRAY
5 for REFERENCE_WITH_NULL

dmitry-lipetsk commented 2 years ago

Ok :)

Answer 1 · 2023-11-13T13:17:23.000Z

Thanks, I'll add it when I have time.

Answer 2 · 2023-11-13T13:17:42.000Z

BTW: Is this only for Firebird 4+ or also for older versions?

Answer 3 · 2023-11-13T14:00:30.000Z

These constants were added in FB v2.0, if I understand correctly.

FB2 source (types.h):

	TYPE("BY_VALUE", 0, nam_mechanism)
	TYPE("BY_REFERENCE", 1, nam_mechanism)
	TYPE("BY_VMS_DESCRIPTOR", 2, nam_mechanism)
	TYPE("BY_ISC_DESCRIPTOR", 3, nam_mechanism)
	TYPE("BY_SCALAR_ARRAY_DESCRIPTOR", 4, nam_mechanism)
	TYPE("BY_REFERENCE_WITH_NULL", 5, nam_mechanism)

FB1.5.4.4910 source (types.h):

	TYPE("BY_VALUE", 0, nam_mechanism)
	TYPE("BY_REFERENCE", 1, nam_mechanism)
	TYPE("BY_VMS_DESCRIPTOR", 2, nam_mechanism)
	TYPE("BY_ISC_DESCRIPTOR", 3, nam_mechanism)
	TYPE("BY_SCALAR_ARRAY_DESCRIPTOR", 4, nam_mechanism)

Although FB1.5 has SCALAR_ARRAY-constant, it does not support the creation of UDF with such arguments (I tested this):

Answer 4 · 2023-11-13T14:06:48.000Z

Given the language references only start at 2.5, the behaviour for Firebird 1.5 is not important :)

Answer 5 · 2023-11-18T15:46:41.000Z

Added to fblangref25 - fblangref50; this will be published at a later time (hoping/waiting for more changes to accumulate).