# SHOW WARNINGS

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_count` variable displays the total number of warnings.
* This command can be run on any SingleStore node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) 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)

```

***

Modified at: January 11, 2023

Source: [/db/v9.1/reference/sql-reference/show-commands/show-warnings/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-warnings/)

(An index of the documentation is available at /llms.txt)