SET ARITHIGNORE#
Controls whether error messages are returned from overflow or divide-by-zero errors during a query.
Syntax#
SET ARITHIGNORE { ON | OFF } [;]
Remarks#
The setting is stored for the session and reported by @@OPTIONS (value 128). It does not change query results:
when ANSI_WARNINGS and ARITHABORT are both OFF, an overflow or divide-by-zero returns NULL, and when either is ON it
raises an error, whatever the ARITHIGNORE setting.
SQL Server also returns an informational message (3606 or 3607) for such a fault when ARITHIGNORE is OFF. Querona never returns that message, so it behaves as if ARITHIGNORE were ON. The setting is not forwarded to data sources.
Permissions#
Requires membership in the public role.