Help Center> GaussDB> Distributed_8.x> Schemas> DBE_SQL_UTIL Schema> DBE_SQL_UTIL.create_abort_sql_patch

Updated on 2024-06-03 GMT+08:00

View PDF

DBE_SQL_UTIL.create_abort_sql_patch

create_abort_sql_patch creates abort SQL patches on the connected CN and returns whether the execution is successful, as described in Table 1.

Only the initial user, sysadmin, opradmin, and monadmin have the permission to call it.

SQL patches are not shared among CNs and need to be created on each CN.
If load balancing is enabled or a CN needs to be specified, you are advised to use the DBE_SQL_UTIL.create_remote_abort_sql_patch API to create a CN.

**Table 1** DBE_SQL_UTIL.create_abort_sql_patch input parameters and return values
Parameter	Type	Description
patch_name	IN name	Patch name.
unique_sql_id	IN bigint	Global unique ID.
description	IN text	Patch description. The default value is NULL.
enabled	IN bool	Specifies whether the patch takes effect. The default value is true.
result	OUT bool	Specifies whether this operation is successful.