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

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

View PDF

DBE_SQL_UTIL.create_hint_sql_patch

create_hint_sql_patch creates hint SQL patches and returns whether the execution is successful. This function is an overloaded function of the original function. The value of parent_unique_sql_id can be used to limit the effective range of the hint patch, as described in Table 1.

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

**Table 1** DBE_SQL_UTIL.create_hint_sql_patch input parameters and return values
Parameter	Type	Description
patch_name	IN name	Patch name.
unique_sql_id	IN bigint	Global unique ID.
parent_unique_sql_id	IN bigint	Global unique ID of the outer SQL statement. The value 0 indicates that the SQL patch statement outside the stored procedure is restricted to take effect. A non-zero value indicates that the specific stored procedure is restricted to take effect.
hint_string	IN text	Hint text.
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.