SET ARITHABORT#
Terminates a query when an overflow or divide-by-zero error occurs during query execution.
Syntax#
SET ARITHABORT { ON | OFF } [;]
Remarks#
When ARITHABORT is ON (or SET ANSI_WARNINGS is ON), an overflow or divide-by-zero error cancels the query and returns an error to the client. When both ARITHABORT and ANSI_WARNINGS are OFF, the faulting expression evaluates to NULL instead. The default for a Querona session is ARITHABORT OFF with ANSI_WARNINGS ON, matching the SQL Server client driver defaults - arithmetic faults raise errors by default.
When a query is pushed down to a SQL Server source, the session’s ARITHABORT and ANSI_WARNINGS state is applied to the source connection first, so the source evaluates arithmetic faults with the same semantics as the Querona session.
Note
Azure Synapse dedicated SQL pools enforce both ARITHABORT and ANSI_WARNINGS ON and reject
SET ... OFF. Arithmetic faults in queries pushed down to such sources always raise errors;
Querona logs a warning when the session requests a state the platform cannot honor.
Permissions#
Requires membership in the public role.