v.24.7Improvement

Add Primary Key Type Validation Option for Dictionaries

Add option for validating the primary key type in Dictionaries. Without this option for simple layouts any column type will be implicitly converted to UInt64. #66595 (MikhailBurdukov).
Add an option to validate the primary key type in Dictionaries to prevent implicit type conversion.

Why it matters

This feature addresses the issue where, without validation, any column type in simple dictionary layouts is implicitly converted to UInt64. By validating the primary key type, users can ensure type correctness and avoid unexpected type casts, improving data integrity and query reliability.

How to use it

Enable the primary key type validation option in the dictionary configuration. When this option is active, ClickHouse will enforce the specified primary key type during dictionary loading, preventing implicit conversions.