v.25.12Improvement
Text index now works with ReplacingMergeTree tables
The text index now works with ReplacingMergeTree tables. #90908 (Elmi Ahmadov).Why it matters
Previously, text indexes could not be used withReplacingMergeTree engine tables, limiting full-text search capabilities on these tables. This feature enables efficient text indexing and search on ReplacingMergeTree tables, enhancing query performance and usability for text-based data.How to use it
Create a text index on aReplacingMergeTree table as usual using the ALTER TABLE ... ADD INDEX ... TYPE text() syntax. The text index will work seamlessly with the replacing merge tree engine for text search operations.