|
Controls the reporting of division by zero.
On, Off
On
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | Yes, with SET ANY PUBLIC OPTION | Yes | Yes, with SET ANY PUBLIC OPTION |
| Allowed to set temporarily? | Yes, with SET ANY PUBLIC OPTION | Yes (current connection only) | No |
This option indicates whether division by zero is reported as an error. If the option is set On, then division by zero results in an error with SQLSTATE '22012'.
If the option is set Off, division by zero is not an error. Instead, a NULL is returned.