Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

SHOW WARNINGS

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_count variable displays the total number of warnings.
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.

SQL

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)