Integer options with minimum and maximum values are now validated.
Setting an option to an invalid value gives the error Invalid
setting for option ‘%1’.
If you run ALTER DATABASE UPGRADE on a database that contains invalid option settings, they are set to the closest legal value.
The affected options are listed in Table 1-1. The square brackets indicate an inclusive range.
Option |
Range |
|---|---|
ISOLATION_LEVEL |
[ 0, 3 ] |
PRECISION |
[ 0, 127 ] |
SCALE |
[ 0, 127 ] |
NEAREST_CENTURY |
[ 0, 100 ] |
MAX_HASH_SIZE |
[ 2, 64 ] |
MAX_WORK_TABLE_HASH_SIIZE |
[ 2, 64 ] |
FIRST_DAY_OF_WEEK |
[ 1, 7 ] |
DEFAULT_TIMESTAMP_INCREMENT |
[ 1, 60 000 000 ] |
