You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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 MemSQL node (see Node Requirements for MemSQL Commands).

Example

The following example shows the warnings and its count after an invalid WHERE statement is run.

memsql> SELECT * FROM t5 WHERE geography_intersects('point(0 0)', 'TestValue');
Empty set, 1 warning (0.46 sec)

memsql> 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)

memsql> SELECT @@warning_count;
+-----------------+
| @@warning_count |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.57 sec)