2025-06-21 03:48:05 Reason: result differs with reference:  
2025-06-21 03:48:05 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02521_aggregation_by_partitions.reference	2025-06-21 03:41:33.308319611 +0200
2025-06-21 03:48:05 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02521_aggregation_by_partitions.stdout	2025-06-21 03:48:05.557208458 +0200
2025-06-21 03:48:05 @@ -8,14 +8,14 @@
2025-06-21 03:48:05        (Expression)
2025-06-21 03:48:05        ExpressionTransform × 4
2025-06-21 03:48:05          (ReadFromMergeTree)
2025-06-21 03:48:05 -        Resize 3 → 1
2025-06-21 03:48:05 -          MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 3 0 → 1
2025-06-21 03:48:05 -            Resize 3 → 1
2025-06-21 03:48:05 -              MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 3 0 → 1
2025-06-21 03:48:05 -                Resize 3 → 1
2025-06-21 03:48:05 -                  MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 3 0 → 1
2025-06-21 03:48:05 -                    Resize 3 → 1
2025-06-21 03:48:05 -                      MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 3 0 → 1
2025-06-21 03:48:05 +        Resize 4 → 1
2025-06-21 03:48:05 +          MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 4 0 → 1
2025-06-21 03:48:05 +            Resize 4 → 1
2025-06-21 03:48:05 +              MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 4 0 → 1
2025-06-21 03:48:05 +                Resize 4 → 1
2025-06-21 03:48:05 +                  MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 4 0 → 1
2025-06-21 03:48:05 +                    Resize 4 → 1
2025-06-21 03:48:05 +                      MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 4 0 → 1
2025-06-21 03:48:05  1000000
2025-06-21 03:48:05  -- { echoOn }
2025-06-21 03:48:05  explain pipeline select a from t2 group by a;
2025-06-21 03:48:05 @@ -54,38 +54,7 @@
2025-06-21 03:48:05        (Expression)
2025-06-21 03:48:05        ExpressionTransform × 16
2025-06-21 03:48:05          (ReadFromMergeTree)
2025-06-21 03:48:05 -        Concat 2 → 1
2025-06-21 03:48:05 -          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -            Concat 2 → 1
2025-06-21 03:48:05 -              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                Concat 2 → 1
2025-06-21 03:48:05 -                  MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                    Concat 2 → 1
2025-06-21 03:48:05 -                      MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                        Concat 2 → 1
2025-06-21 03:48:05 -                          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                            Concat 2 → 1
2025-06-21 03:48:05 -                              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                Concat 2 → 1
2025-06-21 03:48:05 -                                  MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                    Concat 2 → 1
2025-06-21 03:48:05 -                                      MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                        Concat 2 → 1
2025-06-21 03:48:05 -                                          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                            Concat 2 → 1
2025-06-21 03:48:05 -                                              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                Concat 2 → 1
2025-06-21 03:48:05 -                                                  MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                    Concat 2 → 1
2025-06-21 03:48:05 -                                                      MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                        Concat 2 → 1
2025-06-21 03:48:05 -                                                          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                            Concat 2 → 1
2025-06-21 03:48:05 -                                                              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                                Concat 2 → 1
2025-06-21 03:48:05 -                                                                  MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                                                                    Concat 2 → 1
2025-06-21 03:48:05 -                                                                      MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 +        MergeTreeSelect(pool: ReadPool, algorithm: Thread) × 16 0 → 1
2025-06-21 03:48:05  1000000
2025-06-21 03:48:05  1000000
2025-06-21 03:48:05  -- { echoOn }
2025-06-21 03:48:05 @@ -99,18 +68,18 @@
2025-06-21 03:48:05          (Expression)
2025-06-21 03:48:05          ExpressionTransform × 4
2025-06-21 03:48:05            (ReadFromMergeTree)
2025-06-21 03:48:05 -          MergingSortedTransform 2 → 1
2025-06-21 03:48:05 -            ExpressionTransform × 2
2025-06-21 03:48:05 -              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                MergingSortedTransform 2 → 1
2025-06-21 03:48:05 -                  ExpressionTransform × 2
2025-06-21 03:48:05 -                    MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                      MergingSortedTransform 2 → 1
2025-06-21 03:48:05 -                        ExpressionTransform × 2
2025-06-21 03:48:05 -                          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 -                            MergingSortedTransform 2 → 1
2025-06-21 03:48:05 -                              ExpressionTransform × 2
2025-06-21 03:48:05 -                                MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 2 0 → 1
2025-06-21 03:48:05 +          MergingSortedTransform 4 → 1
2025-06-21 03:48:05 +            ExpressionTransform × 4
2025-06-21 03:48:05 +              MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 4 0 → 1
2025-06-21 03:48:05 +                MergingSortedTransform 4 → 1
2025-06-21 03:48:05 +                  ExpressionTransform × 4
2025-06-21 03:48:05 +                    MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 4 0 → 1
2025-06-21 03:48:05 +                      MergingSortedTransform 4 → 1
2025-06-21 03:48:05 +                        ExpressionTransform × 4
2025-06-21 03:48:05 +                          MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 4 0 → 1
2025-06-21 03:48:05 +                            MergingSortedTransform 4 → 1
2025-06-21 03:48:05 +                              ExpressionTransform × 4
2025-06-21 03:48:05 +                                MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder) × 4 0 → 1
2025-06-21 03:48:05  1000000
2025-06-21 03:48:05  -- { echoOn }
2025-06-21 03:48:05  explain pipeline select a from t5 group by a settings read_in_order_two_level_merge_threshold = 1e12;
2025-06-21 03:48:05 
2025-06-21 03:48:05 
2025-06-21 03:48:05 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 442119 --group_by_two_level_threshold_bytes 18082312 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 7048266 --max_read_buffer_size 906468 --prefer_localhost_replica 0 --max_block_size 95094 --max_joined_block_size_rows 14888 --max_threads 3 --optimize_append_index 1 --use_hedged_requests 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 66 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 20525914 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 3900860952 --min_bytes_to_use_mmap_io 1244670820 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_expressions 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 556869322 --min_compress_block_size 1024897 --max_compress_block_size 2487554 --merge_tree_compact_parts_min_granules_to_multibuffer_read 78 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 8178443 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone America/Mazatlan --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.66 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.0 --max_bytes_ratio_before_external_group_by 0.2 --use_skip_indexes_if_final_exact_mode 0
2025-06-21 03:48:05 
2025-06-21 03:48:05 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 17090259 --merge_max_block_size 19347 --index_granularity 7015 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 31676 --primary_key_compress_block_size 20895 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 476502900 --compact_parts_max_bytes_to_buffer 248188793 --compact_parts_max_granules_to_buffer 116 --compact_parts_merge_max_bytes_to_prefetch_part 21302675 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 380 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0
2025-06-21 03:48:05 
2025-06-21 03:48:05 Database: test_i5un52cn