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 ERRORS

Syntax

SHOW ERRORS;

SELECT @@error_count;

Remarks

SHOW ERRORS is a diagnostic statement that displays error information as a result of an invalid statement execution.
@@error_count variable displays the total number of errors.
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
See the Permission Matrix for the required permission.

Examples

The following example shows the errors and its count after an invalid INSERT query is run.

SQL

CREATE TABLE t1 (a TINYINT NOT NULL, B CHAR);

Query OK, 0 rows affected (1.25 sec)

SQL

INSERT INTO t1 VALUES(10,'mysql'), (NULL, 'test'), (300,'xyz');

ERROR 1048 (23000): Leaf Error (127.0.0.1:3307): Column 'a' cannot be null

SQL

SHOW ERRORS;

+-------+------+--------------------------------------------------------+
| Level | Code | Message                                                |
+-------+------+--------------------------------------------------------+
| Error | 1048 | Leaf Error (127.0.0.1:3307): Column 'a' cannot be null |
+-------+------+--------------------------------------------------------+
1 row in set (0.00 sec)

SQL

SELECT @@error_count;

+---------------+
| @@error_count |
+---------------+
|             1 |
+---------------+
1 row in set (0.55 sec)