CREATE TABLE test_wide_nested (`id` Int, `info.id` Array(Int), `info.name` Array(String), `info.age` Array(Int)) ENGINE = MergeTree ORDER BY tuple() SETTINGS min_bytes_for_wide_part = 0
INSERT INTO test_wide_nested SELECT number, [number, number + 1], ['aa', 'bb'], [number, number * 2] FROM numbers(5)
ALTER TABLE test_wide_nested UPDATE `info.id` = [100, 200, 300], `info.age` = [10, 20, 30], `info.name` = ['a', 'b', 'c'] WHERE arrayJoin([100, -2147483647, NULL]) = id