GaussDB-GaussDB-GLOBAL_SQL_PATCH
GLOBAL_SQL_PATCH stores information about all SQL patches. This view is available only in the PG_CATALOG schema.
| Name | Type | Description |
|---|---|---|
| node_name | text | Name of the node where the SQL PATCH is located. |
| patch_name | name | Name of the SQL PATCH. |
| unique_sql_id | bigint | Global unique query ID. |
| owner | oid | ID of the user created using the SQL PATCH. |
| enable | boolean | Specifies whether the SQL patch takes effect. |
| status | "char" | SQL patch status (reserved column). |
| abort | boolean | Specifies whether a hint is discarded. |
| hint_string | text | Hint text. |
| description | text | SQL patch description. |
| parent_unique_sql_id | bigint | Globally 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…