v.20.10Improvement

Ignore Key Constraints in Mutations with Index and Primary Key Flags

Official CH changelog text
Ignore key constraints when doing mutations. Without this pull request, it's not possible to do mutations when force_index_by_date = 1 or force_primary_key = 1. #14973 (Amos Bird).
Adds the ability to ignore key constraints when performing mutations, enabling mutations even when force_index_by_date = 1 or force_primary_key = 1 are set.

Why it matters

Before this feature, performing mutations was blocked if either force_index_by_date or force_primary_key settings were enabled, limiting flexibility during data modification. This update removes that restriction, allowing users to mutate data regardless of these constraints, thereby enhancing mutation capabilities and operational flexibility.

How to use it

Users can perform mutations as usual with MUTATE queries even when the settings force_index_by_date = 1 or force_primary_key = 1 are active, without additional configuration required.

Related resources

PreviousNext