Help Center/ GaussDB/ Developer Guide(Distributed_3.x)/ Schemas/ DBE_SQL_UTIL Schema/ DBE_SQL_UTIL.create_remote_hint_sql_patch
Updated on 2024-05-07 GMT+08:00

DBE_SQL_UTIL.create_remote_hint_sql_patch

create_remote_hint_sql_patch creates hint SQL patches on a specified CN and 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_remote_hint_sql_patch input parameters and return values

Parameter

Type

Description

node_name

IN text

Destination node name.

patch_name

IN name

Patch name.

unique_sql_id

IN bigint

Global unique query 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.

result

OUT bool

Specifies whether this operation is successful.