Help Center/ GaussDB/ Centralized_2.x/ Schemas/ DBE_SQL_UTIL Schema/ DBE_SQL_UTIL.create_hint_sql_patch

Updated on 2023-10-23 GMT+08:00

View PDF

DBE_SQL_UTIL.create_hint_sql_patch

create_hint_sql_patch is an interface function used to create SQL patches for hints. It returns whether the execution is successful.

Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.

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