v.21.1New Features
Add Mutation Support for StorageMemory
Add mutation support for StorageMemory. This closes #9117. #15127 (flynn).
Why it matters
Before this feature, theMemory storage engine did not support mutations, which limited the ability to perform UPDATE or DELETE operations on in-memory tables. This enhancement allows users to perform mutations on Memory tables, enabling more flexible and dynamic in-memory data manipulations.How to use it
Users can now perform mutation queries such asALTER TABLE memory_table DELETE WHERE condition or ALTER TABLE memory_table UPDATE column = value WHERE condition on tables created with the Memory engine, just like with other mutable table engines.