Primary/Secondary Indices with Identical Expressions Rejected by Default
Official CH changelog text
Primary/secondary indices and sorting keys with identical expressions are now rejected. This behavior can be disabled using setting allow_suspicious_indices. #48536 (凌涛).