After upgrading a 12.5.3a server to 15.0 EC or loading a dump from an Adaptive Server 1253a database into an Adaptive Server 15.0 EC server, you must update the column statistics if your 1253a database contains encrypted columns that belong to one or more indices After loading the dump, run this command on all tables that contain an encrypted column used in an index:
update statistics table_name (encrypted_column_name [,encrypted_column_name])
If you do not run update statistics on the encrypted columns, statements that access these columns fail with a stack trace printed to the error log. Adaptive Server The command is aborted and the user session is terminated by Adaptive Server.
WARNING! The consistency issues between encryption keys and encrypted columns are similar to those for cross-database referential integrity. See “Cross-database constraints and loading databases” in Chapter 12 of the Adaptive Server Enterprise System Administration Guide: Volume One.
