2026-03-26 10:12:51 Reason: result differs with reference:  
2026-03-26 10:12:51 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03706_statistics_preserve_checksums_on_mutations.reference	2026-03-26 09:55:56.457920877 +0100
2026-03-26 10:12:51 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03706_statistics_preserve_checksums_on_mutations.4824.stdout	2026-03-26 10:12:51.152166492 +0100
2026-03-26 10:12:51 @@ -2,11 +2,11 @@
2026-03-26 10:12:51  select count() from mt;
2026-03-26 10:12:51  10000
2026-03-26 10:12:51  -- { echo }
2026-03-26 10:12:51  alter table mt rewrite parts settings mutations_sync=2;
2026-03-26 10:12:51  select count() from mt;
2026-03-26 10:12:51  10000
2026-03-26 10:12:51  detach table mt;
2026-03-26 10:12:51  attach table mt;
2026-03-26 10:12:51  select count() from mt;
2026-03-26 10:12:51  10000
2026-03-26 10:12:51 -Hashes are the same
2026-03-26 10:12:51 +Hashes does not matches: '('efd5f8d65343945e62a627ceb0f3d4b2','4a956ee063ad0041686bc4b7280a09fc','4a6f3b0a3c497e78ad3b05c9753899f6')' vs '('1a2b1d28b1ce8fd74ed022131938145f','750357b082212bbb5beee779336ad4cc','4a6f3b0a3c497e78ad3b05c9753899f6')'
2026-03-26 10:12:51 
2026-03-26 10:12:51 
2026-03-26 10:12:51 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_23nxuuhg/03706_statistics_preserve_checksums_on_mutations.sh.debuglog:
2026-03-26 10:12:51 + [2026-03-26 10:12:43] [:9] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_23nxuuhg --log_comment 03706_statistics_preserve_checksums_on_mutations.sh-test_23nxuuhg --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 16578852 --max_read_buffer_size 864062 --prefer_localhost_replica 1 --max_block_size 84779 --max_joined_block_size_rows 67537 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 124 --max_threads 1 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 63 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 3506469 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 215332909 --min_bytes_to_use_mmap_io 2838277088 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 1 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 0 --enable_filesystem_cache_on_write_operations 1 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 1002207258 --min_compress_block_size 2116623 --max_compress_block_size 2159522 --merge_tree_compact_parts_min_granules_to_multibuffer_read 13 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 701795 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache True --use_page_cache_for_local_disks False --use_page_cache_for_object_storage False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.6 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 1 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 1 --optimize_rewrite_array_exists_to_has True --optimize_skip_unused_shards False --optimize_trivial_approximate_count_query True --optimize_trivial_insert_select False --optimize_using_constraints True --optimize_syntax_fuse_functions False --optimize_aggregators_of_group_by_keys True --optimize_and_compare_chain True --optimize_arithmetic_operations_in_aggregate_functions True --optimize_count_from_files True --optimize_distributed_group_by_sharding_key True --optimize_empty_string_comparisons True --optimize_group_by_constant_keys True --optimize_group_by_function_keys True --optimize_injective_functions_in_group_by True --optimize_injective_functions_inside_uniq True --optimize_inverse_dictionary_lookup True --optimize_move_to_prewhere True --optimize_multiif_to_if True --optimize_normalize_count_variants True --optimize_on_insert True --optimize_redundant_functions_in_order_by True --optimize_respect_aliases True --optimize_rewrite_aggregate_function_with_if True --optimize_rewrite_regexp_functions True --optimize_rewrite_sum_if_to_count_if True --optimize_skip_unused_shards_rewrite_in True --optimize_time_filter_with_preimage True --optimize_trivial_count_query True --optimize_uniq_to_count True --optimize_use_projections True --optimize_use_implicit_projections True --optimize_use_projection_filtering False --query_plan_optimize_lazy_materialization True --query_plan_optimize_prewhere True --use_async_executor_for_materialized_views 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --use_skip_indexes_for_top_k 1 --use_top_k_dynamic_filtering 0 --query_plan_max_limit_for_top_k_optimization 10 --query_plan_read_in_order_through_join 1 --read_in_order_use_virtual_row 1 --short_circuit_function_evaluation_for_nulls_threshold 0.9376975601065888 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 1204131 --query_plan_optimize_join_order_algorithm greedy,dpsize --normalize_function_names True --enable_join_runtime_filters True --enable_parallel_blocks_marshalling True --query_plan_reuse_storage_ordering_for_window_functions False --query_plan_join_shard_by_pk_ranges False --count_distinct_optimization True --use_statistics True --use_statistics_cache True --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.1 --max_bytes_ratio_before_external_group_by 0.0 --use_skip_indexes_if_final_exact_mode 1 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 9618698673 --index_granularity_bytes 30722491 --merge_max_block_size 23158 --index_granularity 17260 --min_bytes_for_wide_part 0 --marks_compress_block_size 76105 --primary_key_compress_block_size 32982 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 390552953 --compact_parts_max_bytes_to_buffer 524787722 --compact_parts_max_granules_to_buffer 141 --compact_parts_merge_max_bytes_to_prefetch_part 32627510 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 10 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 --object_serialization_version v2 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts map --object_shared_data_buckets_for_compact_part 9 --object_shared_data_buckets_for_wide_part 16 --dynamic_serialization_version v2 --auto_statistics_types uniq --serialization_info_version with_types --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 778 --reduce_blocking_parts_sleep_ms 1089 --shared_merge_tree_outdated_parts_group_size 1 --shared_merge_tree_max_outdated_parts_to_process_at_once 2 --map_serialization_version with_buckets --map_serialization_version_for_zero_level_parts basic --max_buckets_in_map 86 --map_buckets_strategy linear --map_buckets_min_avg_size 693 --allow_repeated_settings --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03706_statistics_preserve_checksums_on_mutations.4824.stderr-fatal -nm -q '
2026-03-26 10:12:51 drop table if exists mt;
2026-03-26 10:12:51 create table mt (key Int, value String) engine=MergeTree() order by key settings
2026-03-26 10:12:51   index_granularity=100,
2026-03-26 10:12:51   index_granularity_bytes=10e6,
2026-03-26 10:12:51   min_bytes_for_wide_part=0,
2026-03-26 10:12:51   -- otherwise sparse info will be different, since for INSERTs the sparse ratio is calculated for the whole block, while for mutations for each granula (FIXME?)
2026-03-26 10:12:51   ratio_of_defaults_for_sparse_serialization=1,
2026-03-26 10:12:51   -- This uncovers the bug
2026-03-26 10:12:51   auto_statistics_types='\''uniq,minmax,countmin,tdigest'\''
2026-03-26 10:12:51 ;
2026-03-26 10:12:51 insert into mt select number, repeat('\''a'\'', number) from numbers(10e3) settings max_block_size=1e6;
2026-03-26 10:12:51 -- { echo }
2026-03-26 10:12:51 select count() from mt;
2026-03-26 10:12:51 '
2026-03-26 10:12:51 ++ [2026-03-26 10:12:45] [:25] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_23nxuuhg --log_comment 03706_statistics_preserve_checksums_on_mutations.sh-test_23nxuuhg --max_insert_threads 1 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 16578852 --max_read_buffer_size 864062 --prefer_localhost_replica 1 --max_block_size 84779 --max_joined_block_size_rows 67537 --joined_block_split_single_row 0 --join_output_by_rowlist_perkey_rows_threshold 124 --max_threads 1 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 63 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 3506469 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 215332909 --min_bytes_to_use_mmap_io 2838277088 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 1 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 0 --enable_filesystem_cache_on_write_operations 1 --compile_expressions 1 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 27 --optimize_distinct_in_order 1 --max_bytes_before_remerge_sort 1002207258 --min_compress_block_size 2116623 --max_compress_block_size 2159522 --merge_tree_compact_parts_min_granules_to_multibuffer_read 13 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 701795 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache True --use_page_cache_for_local_disks False --use_page_cache_for_object_storage False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.6 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 1 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 1 --optimize_rewrite_array_exists_to_has True --optimize_skip_unused_shards False --optimize_trivial_approximate_count_query True --optimize_trivial_insert_select False --optimize_using_constraints True --optimize_syntax_fuse_functions False --optimize_aggregators_of_group_by_keys True --optimize_and_compare_chain True --optimize_arithmetic_operations_in_aggregate_functions True --optimize_count_from_files True --optimize_distributed_group_by_sharding_key True --optimize_empty_string_comparisons True --optimize_group_by_constant_keys True --optimize_group_by_function_keys True --optimize_injective_functions_in_group_by True --optimize_injective_functions_inside_uniq True --optimize_inverse_dictionary_lookup True --optimize_move_to_prewhere True --optimize_multiif_to_if True --optimize_normalize_count_variants True --optimize_on_insert True --optimize_redundant_functions_in_order_by True --optimize_respect_aliases True --optimize_rewrite_aggregate_function_with_if True --optimize_rewrite_regexp_functions True --optimize_rewrite_sum_if_to_count_if True --optimize_skip_unused_shards_rewrite_in True --optimize_time_filter_with_preimage True --optimize_trivial_count_query True --optimize_uniq_to_count True --optimize_use_projections True --optimize_use_implicit_projections True --optimize_use_projection_filtering False --query_plan_optimize_lazy_materialization True --query_plan_optimize_prewhere True --use_async_executor_for_materialized_views 0 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 0 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 0 --allow_special_serialization_kinds_in_output_formats 0 --use_skip_indexes_for_top_k 1 --use_top_k_dynamic_filtering 0 --query_plan_max_limit_for_top_k_optimization 10 --query_plan_read_in_order_through_join 1 --read_in_order_use_virtual_row 1 --short_circuit_function_evaluation_for_nulls_threshold 0.9376975601065888 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 1204131 --query_plan_optimize_join_order_algorithm greedy,dpsize --normalize_function_names True --enable_join_runtime_filters True --enable_parallel_blocks_marshalling True --query_plan_reuse_storage_ordering_for_window_functions False --query_plan_join_shard_by_pk_ranges False --count_distinct_optimization True --use_statistics True --use_statistics_cache True --max_bytes_before_external_sor