v.23.8Improvement

Added No-Op Support for CREATE UNIQUE INDEX in SQL Parser

Official CH changelog text
Added support of syntax CREATE UNIQUE INDEX in parser as a no-op for better SQL compatibility. UNIQUE index is not supported. Set create_index_ignore_unique = 1 to ignore UNIQUE keyword in queries. #52320 (Ilya Yatsishin).
Added support for the CREATE UNIQUE INDEX syntax in ClickHouse parser as a no-op to improve SQL compatibility.

Why it matters

This feature allows users to run SQL queries containing CREATE UNIQUE INDEX without errors, even though ClickHouse does not support unique indexes. It enhances compatibility with SQL scripts and tools expecting this syntax.

How to use it

To enable ignoring the UNIQUE keyword in index creation, set the setting create_index_ignore_unique = 1 before running queries with CREATE UNIQUE INDEX statements.

Related resources

PreviousNext