Updated on 2024-05-07 GMT+08:00

GS_SQL_PATCH

GS_SQL_PATCH records the status information about all SQL patches.

Table 1 GS_SQL_PATCH columns

Name

Type

Description

patch_name

name

Patch name.

unique_sql_id

bigint

Global unique ID.

owner

oid

ID of the user who creates the patch.

enable

boolean

Specifies whether the patch takes effect.

status

"char"

Patch status (reserved column).

abort

boolean

Specifies whether the patch is an abort hint.

hint_string

text

Hint text.

hint_node

pg_node_tree

Hint parsing and serialization result.

original_query

text

Original statement (reserved column).

patched_query

text

Patched statement (reserved column).

original_query_tree

pg_node_tree

Original statement parsing result (reserved column).

patched_query_tree

pg_node_tree

Patched statement parsing result (reserved column).

description

text

Patch description.

parent_unique_sql_id

bigint

Globally unique ID of the outer statement of the SQL statement for which the patch takes effect. The value of this parameter is 0 for statements outside a stored procedure. For statements inside the stored procedure, and the value of this parameter is the globally unique ID of the statement that invokes the stored procedure.