SHOW WARNINGS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Display warnings as a result of an invalid statement execution.
Syntax
SHOW WARNINGS
SELECT @@warning_count;
Remarks
-
SHOW WARNINGS
is a diagnostic statement that displays warning information as a result of an invalid statement execution in the current session. -
@@warning_
variable displays the total number of warnings.count -
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
-
See the Permission Matrix for the required permission.
Example
The following example shows the warnings and its count after an invalid WHERE
statement is run.
SELECT * FROM t5 WHERE geography_intersects('point(0 0)', 'TestValue');Empty set, 1 warning (0.46 sec)SHOW WARNINGS;+---------+------+----------------------------------------------------+| Level | Code | Message |+---------+------+----------------------------------------------------+| Warning | 1862 | You have an error in your WKT syntax at position 0 |+---------+------+----------------------------------------------------+1 row in set (0.00 sec)SELECT @@warning_count;+-----------------+| @@warning_count |+-----------------+| 1 |+-----------------+1 row in set (0.57 sec)
Last modified: January 11, 2023