Got wrong result when executing mutation on Memory table engine #24192
Description
Clickhouse version: 21.2.5.5
Got wrong result when excuting mutation on Memory table engine.
CREATE TABLE mem_test(id Int64) ENGINE=Memory();
INSERT INTO mem_test VALUES (1), (2), (3);
ALTER TABLE mem_test UPDATE id=4 WHERE id=1;
SELECT count(*) FROM mem_test;
┌─count()─┐
│ 24 │
└─────────┘
SELECT * FROM mem_test;
┌─id─┐
│ 4 │
│ 2 │
│ 3 │
└────┘
3 rows in set. Elapsed: 0.001 sec.