MySQL [test]> set sql_mode='';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MySQL [test]> select log(-1);
|
+---------+
|
| log(-1) |
|
+---------+
|
| NULL |
|
+---------+
|
1 row in set, 1 warning (0.00 sec)
|
|
MySQL [test]> show warnings;
|
+---------+------+--------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------+
|
| Warning | 3020 | Invalid argument for logarithm |
|
+---------+------+--------------------------------+
|
1 row in set (0.01 sec)
|
|
MySQL [test]> set sql_mode='ERROR_FOR_DIVISION_BY_ZERO';
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
MySQL [test]> select log(-1);
|
+---------+
|
| log(-1) |
|
+---------+
|
| NULL |
|
+---------+
|
1 row in set, 1 warning (0.00 sec)
|
|
MySQL [test]> show warnings;
|
+---------+------+--------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------+
|
| Warning | 3020 | Invalid argument for logarithm |
|
+---------+------+--------------------------------+
|
1 row in set (0.00 sec)
|