Categories:

System functions (System Control)

SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS

Returns the status of the specified behavior change release bundle for the current account.

See also:

SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES

Syntax

SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS( '<bundle_name>' )
Copy

Arguments

bundle_name

Name of the behavior change bundle, specified as a string. To obtain the name for a bundle, see Behavior Change Log.

Returns

Returns one of the following VARCHAR values:

  • ENABLED (if the specified bundle is enabled for the current account)

  • DISABLED (if the specified bundle is disabled for the current account)

  • RELEASED (if the specified bundle is generally enabled for the current account and thus permanently enabled)

Examples

The following example returns the status of the 2020_08 behavior change bundle for the current account.

SELECT SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS('2020_08');
Copy
+-------------------------------------------------+
| SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS('2020_08') |
|-------------------------------------------------|
| DISABLED                                        |
+-------------------------------------------------+