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

[dmitry-lipetsk]

This column can also contain the following values:

• 4 for SCALAR_ARRAY
• 5 for REFERENCE_WITH_NULL

[mrotteveel]

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

[mrotteveel]

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

[dmitry-lipetsk]

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):

[mrotteveel]

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

[dmitry-lipetsk]

Ok :)

[mrotteveel]

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