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

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
  ...

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