In-Memory Row-Level Versioning Restrictions

The in-memory row-level versioning feature has some restrictions including aggregation preference, table type, and data type.

Feature	Restriction
Server Types	Only single-server configurations are supported: tables cannot be enabled for row-level versioning in a multiplex configuration.
Table Types	Only SAP Sybase IQ base tables are supported in the RLV store: catalog, temporary and global temporary tables are not supported.
Data Types	LONG BINARY (LOB) and LONG VARCHAR (CLOB) data types are not supported on RLV-enabled tables. You cannot add a LOB column to an RLV-enabled table. You cannot enable RLV storage on a TLV table with a LOB column.
Index Types	TEXT indexes and WORD indexes are not supported on RLV-enabled tables.
Constraint Types	Foreign key constraints are not supported on RLV-enabled tables or across a combination of RLV-enabled and TLV tables. Referential integrity is not supported. You cannot add a foreign key constraint to an RLV-enabled table. You cannot enable RLV storage on a TLV table that has a foreign key constraint defined. You cannot enable RLV storage on a TLV table if another table has a foreign key constraint referencing this table. When altering a TLV table, you cannot add a foreign key reference to an RLV table.
SQL Statements	The LOCK TABLE statement is not supported on RLV-enabled tables. The BEGIN PARALLEL IQ...END PARALLEL IQ statement results in an error if one of its CREATE INDEX statements specifies an RLV-enabled table. The TRUNCATE statement will result in an error if the PARTITION or SUBPARTITION clause specifies an RLV-enabled table.
Database Options	REVERT_TO_V15_OPTIMIZER='ON' results in an error if your query specifies an RLV-enabled table.