CREATE TABLE mid_replacing_kv (mid_seq_from UInt32, mid_seq UInt32) ENGINE = Join(ANY, LEFT, mid_seq_from);

INSERT INTO mid_replacing_kv(mid_seq_from, mid_seq) VALUES (5, 4), (10, 3);
-- expect 4, get 4
SELECT joinGet('mid_replacing_kv', 'mid_seq', toUInt32(5));

INSERT INTO mid_replacing_kv(mid_seq_from, mid_seq) VALUES (5, 2);
-- expect 2, get 4
SELECT joinGet('mid_replacing_kv', 'mid_seq', toUInt32(5));

-- error
ALTER TABLE mid_replacing_kv UPDATE mid_seq=2 WHERE mid_seq_from=5;
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: Mutations are not supported by storage Join. 

-- With https://github.com/ClickHouse/ClickHouse/pull/7359
-- Out of memory
WITH ['tag1', 'tag2', 'tag3', 'tag4', 'tag5', 'tag6', 'tag7', 'tag8'] AS tag_ids,
     toDateTime('2000-01-01 00:00:00') AS ts_begin,
     addSeconds(toDateTime('2000-01-01 00:00:00'), 1e8) AS ts_end
SELECT arrayFirst(t -> bitmapContains(joinGet('cdp_tags_kv', 'mid_seqs', t), mid_seq), tag_ids) AS tag, count() AS gc, sum(order_total_sales) AS total
FROM cdp_orders
PREWHERE order_complete_time >= ts_begin AND order_complete_time < ts_end
GROUP BY tag;