GaussDB-GaussDB-GLOBAL_SQL_PATCH

39 阅读1分钟

GaussDB-GaussDB-GLOBAL_SQL_PATCH

GLOBAL_SQL_PATCH stores information about all SQL patches. This view is available only in the PG_CATALOG schema.

NameTypeDescription
node_nametextName of the node where the SQL PATCH is located.
patch_namenameName of the SQL PATCH.
unique_sql_idbigintGlobal unique query ID.
owneroidID of the user created using the SQL PATCH.
enablebooleanSpecifies whether the SQL patch takes effect.
status"char"SQL patch status (reserved column).
abortbooleanSpecifies whether a hint is discarded.
hint_stringtextHint text.
descriptiontextSQL patch description.
parent_unique_sql_idbigintGlobally unique ID of the outer statement of the SQL statement for which SQL patch takes effect.- Its value is 0 for statements outside the stored procedure.
  • For a statement within a stored procedure, the value is the globally unique ID of the statement that calls the stored procedure. |

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…