SHOW ALL WARNINGS command¶
The SHOW ALL WARNINGS command shows all the warnings that are generated from previous query executions in the service group. Warnings alert users to non-critical issues without raising an exception or terminating the query.
Note
As warnings are stored in the memory of the Graph service, they are automatically cleared when the Graph service is stopped or restarted. To avoid high memory usage, you can use CLEAR WARNINGS or CLEAR ALL WARNINGS to clear warnings.
The following table describes the returned information:
| Column | Description |
|---|---|
code |
The warning code. |
username |
The username of the user who executed the query that resulted in the warning. |
nums |
The number of the warning occurred in the service group. |
To suppress a warning, you can set the value of the configuration option suppressed_warning_codes to the related warning code using GLOBAL SET.
Prerequisites¶
You must be the user with the role ADMIN in the service group. For more information, see Roles and privileges.
Syntax¶
- show_all_warnings_command
show_all_warnings_command ::=
'SHOW' 'ALL' 'WARNINGS'
Examples¶
SHOW ALL WARNINGS
Return:
+-------+--------------------+------+
| code | username | nums |
+-------+--------------------+------+
| 01005 | user_show_warnings | 1 |
| 01005 | root | 1 |
+-------+--------------------+------+