v.23.7Improvement
Added allow_create_index_without_type Setting for INDEX Queries
Addedallow_create_index_without_typesetting that allow to ignoreADD INDEXqueries without specifiedTYPE. Standard SQL queries will just succeed without changing table schema. #52056 (Ilya Yatsishin).
Why it matters
This feature solves the issue where standard SQL queries usingADD INDEX without a TYPE would fail. By allowing these queries to succeed without altering the schema, it improves compatibility and prevents errors during schema changes initiated by such queries.How to use it
Enable the feature by settingallow_create_index_without_type to true in your session or server settings. After enabling, ADD INDEX queries without a TYPE will complete successfully without modifying the table schema.