SHOW FUNCTIONS and SHOW PROCEDURES commands: Output displays complete data type for arguments (Preview)¶

When this behavior change bundle is enabled, the output of the SHOW command for functions and procedures will display complete data types (when the type is not the default) for function and procedure arguments.

Before the change:

When you execute the SHOW PROCEDURES or SHOW FUNCTIONS command, values in the ARGUMENT column do not always include the complete data type—including the type’s precision—when the type isn’t the default.

For example, when an argument in the column’s value is NUMBER(20, 0), the displayed value is simply NUMBER, as in the following example:

MY_UDF(TIMESTAMP_NTZ, TIMESTAMP_LTZ, TIMESTAMP_TZ, VARCHAR, NUMBER) RETURN NUMBER

This makes the signature less useful when you want to use it with commands such as DESC, DROP, or GET_DDL, where the incomplete signature would result in a name resolution failure.

After the change:

When you execute the SHOW PROCEDURES or SHOW FUNCTIONS command, values in the ARGUMENT column include the complete data type—including the type’s precision—when the type isn’t the default.

For example, when an argument in the column’s value is NUMBER(20, 0), the displayed value is NUMBER(20, 0), as in the following example:

MY_UDF(TIMESTAMP_NTZ(3), TIMESTAMP_LTZ(3), TIMESTAMP_TZ(3), VARCHAR(100), NUMBER(20,0)) RETURN NUMBER(20,0)

You can use this column value with commands such as DESC, DROP, or GET_DDL.

This change affects the following types when the precision of the type used for the argument isn’t the default:

• NUMBER

• VARCHAR

• BINARY

• TIMESTAMP_LTZ

• TIMESTAMP_NTZ

• TIMESTAMP_TZ

• TIME

Ref: 1944