ERROR_FOR_DIVISION_BY_ZERO question

[Paul Silevitch]

Hello all,

Currently, if I use sql_mode ERROR_FOR_DIVISION_BY_ZERO and have a select 
statement that has division by zero, I get back a warning:

mysql> set sql_mode=ERROR_FOR_DIVISION_BY_ZERO;
Query OK, 0 rows affected (0.00 sec)

mysql> select 1/0;
+------+
| 1/0  |
+------+
| NULL |
+------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings;
+-------+------+---------------+
| Level | Code | Message       |
+-------+------+---------------+
| Error | 1365 | Division by 0 |
+-------+------+---------------+
1 row in set (0.00 sec)

Is there a way to force an error instead?

Thanks,

Paul