Behavior Changes in SP2

SAP Sybase IQ 16.0 SP2 introduces several behavior changes.

• Database Option Changes
  If you are updating from an earlier release of SAP Sybase IQ, the truncation behavior and maximum values of some database options has changed in release 16.0 SP2.
• Encryption Support Changes
  SAP Sybase IQ includes OpenSSL encryption libraries that provide strong encryption for LinuxAMD64 Server, LinuxAMD32 Client, and Windows32 Client. Certicom encryption libraries are no longer supplied on these platforms. Encryption providers have not changed for jConnect, Open Client, and SAP Control Center components.
• SAP Sybase IQ Implicitly Rebuilds Wide Columns
  SAP Sybase IQ implicitly rebuilds CHAR,VARCHAR, BINARY, and VARBINARY columns wider than 255 characters, as well as all LONG VARCHAR and LONG BINARY columns in databases migrated to SAP Sybase IQ 16.0 SP03 the first time a pre-16.0 non-RLV base table is opened for read-write access.
• IS [NOT] DISTINCT FROM Search Condition Support
  The ANSI SQL search conditions IS DISTINCT FROM and IS NOT DISTINCT FROM are now supported in SAP Sybase IQ 16.0 SP2.
• Query Plan Changes
  SAP Sybase IQ 16.0 SP2 introduces new query plan nodes.
• SQL Statement Changes
  Syntax changes for SAP Sybase IQ 16.0 SP2.
• Stored Procedure Changes
  Catalog stored procedure and system stored procedure changes for SAP Sybase IQ 16.0 SP2.
• Table and View Changes
  SAP Sybase IQ 16.0 SP2 includes a new system table named ISYSIQMPXSERVERAGENT.
• Deprecated Features
  SAP Sybase IQ no longer supports these features. All deprecated features will be removed in a future release.