Is there a way to log SQL warnings on a MariaDB server (10.2)?
For example, I would like to be able to record (in a log file) this type of warning (strict mode is disabled in this example):
MariaDB [mysql]> select now() = 1;
+-----------+
| now() = 1 |
+-----------+
| 0 |
+-----------+
1 row in set, 1 warning (0.00 sec)
MariaDB [mysql]> show warnings;
+---------+------+-------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------+
| Warning | 1292 | Incorrect datetime value: '1' |
+---------+------+-------------------------------+
1 row in set (0.00 sec)