v.23.9Improvement

Always Allow Creation of Projection with Nullable PK

Always allow the creation of a projection with Nullable PK. This fixes #54814. #54895 (Amos Bird).
Allow the creation of projections with Nullable primary keys in ClickHouse.

Why it matters

This feature resolves the issue where projections could not be created if the primary key contained Nullable columns. It enables more flexible table definitions and indexing strategies, allowing users to leverage projections even when their primary keys include nullable data.

How to use it

Users can create projections on tables that have Nullable columns in their primary key without any additional configuration. Simply define the projection as usual with a primary key containing nullable columns.