Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
allow_alter_system
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | Allows running the ALTER SYSTEM command. Can be set to off for environments where global configuration changes should be made using a different method. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | allow_alter_system |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | Treats "expr=NULL" as "expr IS NULL". When turned on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct behavior of expr = NULL is to always return null (unknown). |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
allow_alter_system
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | Enable/Disable allow alter system command. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | allow_alter_system |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |
transform_null_equals
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Other Platforms and Clients |
| Description | When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | transform_null_equals |