Check Primary Key Type for Simple Dictionary and Add Compatibility Setting

Why it matters

This feature ensures compatibility and correctness by verifying that the primary key type used in simple dictionaries is a native unsigned integer type. It helps prevent potential issues caused by incompatible primary key types. Users can disable the check if needed for backward compatibility or specific use cases.

How to use it

Enable or disable the primary key type check by setting the check_dictionary_primary_key parameter. By default, the check is enabled. To disable it, set:

SET check_dictionary_primary_key = false