Default Column Compare Modes for Comparisons

A comparison uses a set of options to compare tables defined in a compareset.

Use the default_column_compare_mode configuration option to set the default column comparison option for a comparison. This configuration option is not used, if you explicitly define all column compare modes when you create the comparison.

The default column compare mode for compareset key columns is literal, regardless of the column type.

All compareset non-key columns default to the default_column_compare_mode value.

Rules that apply to select the default column compare mode for compareset non-key columns:

When the config option default_column_compare_mode is literal, the column compare mode is literal.
When the config option default_column_compare_mode is column_hash, and if the hash_type comparison option is agent_hash, the column compare mode is column_hash.
When the config option default_column_compare_mode is row_hash, and if the hash_type comparison option is agent_hash, the column compare mode is row_hash.

When the default_column_compare_mode configuration option is row_hash or column_hash, and the hash_type comparison option is set to database_hash, a different set of rules apply. See Database Hash and Default Column Compare Modes.