Backward Compatibility: Changes to Default Behavior

The default behavior of the initial 16.0 version has changed in some areas.

• Constraint Violation Checks
  The order in which the database server evaluates check constraints and unique constraints has changed in SAP Sybase IQ 16.0. This behavior change occurs only for LOAD or INSERT statements containing the clause IGNORE CONSTRAINT CHECK <x>, UNIQUE <y>.
• Database Options: Changed Defaults
  If you are upgrading from an earlier release of SAP Sybase IQ, note that default values of some database options changed in release 16.0.
• Reserved Words
  Reserved words in SAP Sybase IQ 16.0.