MAX_WARNINGS option

Function

Controls the maximum number of warnings allowed.

Allowed values

Any integer

Default

248 - 1

Scope

DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

This option can limit the number of warnings about rejected values, row mismatches, and so on during DDL commands. The default does not restrict the number you can receive.