FUNCTIONS and PROCEDURES views (INFORMATION_SCHEMA): Corrections to columns When name contains special characters (Pending)

Attention

This behavior change is in the 2023_08 bundle.

For the current status of the bundle, refer to Bundle History.

This behavior change affects UDFs and stored procedures that have names or argument names containing any of the following characters:

  • A colon ( : )

  • An open parenthesis ( ( )

  • A close parenthesis ( ) )

In the INFORMATION_SCHEMA FUNCTIONS and PROCEDURES views, the argument_signature and data_type columns contain the following values for these functions and procedures:

Before the change

argument_signature and data_type do not contain the correct argument signature and return data type.

The value in the argument_signature column might contain an open parenthesis or the part of the function or procedure name that starts with an open parenthesis.

The value in the data_type column might contain the prefix TABLE.

After the change

argument_signature and data_type contain the correct argument signature and return data type.

For example, suppose that a UDF name contains a colon:

CREATE OR REPLACE FUNCTION "passthrough:function"(arg VARCHAR)
  RETURNS VARCHAR
  ...
Copy

The argument_signature and data_type columns contain the following values:

Before the change
+--------------------+------------------------+
| ARGUMENT_SIGNATURE | DATA_TYPE              |
|--------------------+------------------------|
| (                  | TABLEVARCHAR(16777216) |
+--------------------+------------------------+
After the change
+--------------------+-------------------+
| ARGUMENT_SIGNATURE | DATA_TYPE         |
|--------------------+-------------------|
| (ARG VARCHAR)      | VARCHAR(16777216) |
+--------------------+-------------------+

Note that this change just addresses the problem in the FUNCTIONS and PROCEDURES views in INFORMATION_SCHEMA. The fix for the FUNCTIONS and PROCEDURES views in ACCOUNT_USAGE will be made available in a future behavior change release.

Ref: 1404