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

GS_SQL_PATCH

GS_SQL_PATCH stores the status information about all SQL_PATCH statements. Currently, this function is not supported in distributed mode.

Table 1 GS_SQL_PATCH columns

Name

Type

Description

patch_name

name

Patch name.

unique_sql_id

bigint

Queries the global unique ID.

owner

oid

ID of the user who creates the patch.

enable

bool

Determines whether the patch takes effect.

status

"char"

Patch status (reserved field).

abort

bool

Determines whether the value is AbortHint.

hint_string

text

Hint text.

hint_node

pg_node_tree

Hint parsing and serialization result.

original_query

text

Original statement (reserved field).

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.