2025-03-19 10:13:03 Reason: result differs with reference:  
2025-03-19 10:13:03 --- /repo/tests/queries/0_stateless/02941_variant_type_4.reference	2025-03-19 09:59:53.644059819 +0100
2025-03-19 10:13:03 +++ /repo/tests/queries/0_stateless/02941_variant_type_4.stdout	2025-03-19 10:13:03.916941633 +0100
2025-03-19 10:13:03 @@ -36,6 +36,6 @@
2025-03-19 10:13:03  1000000
2025-03-19 10:13:03  200000
2025-03-19 10:13:03  200000
2025-03-19 10:13:03 -200000
2025-03-19 10:13:03 +200001
2025-03-19 10:13:03  200000
2025-03-19 10:13:03  -----------------------------------------------------------------------------------------------------------
2025-03-19 10:13:03 
2025-03-19 10:13:03 
2025-03-19 10:13:03 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 148023 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 12590649 --max_read_buffer_size 910614 --prefer_localhost_replica 1 --max_block_size 96131 --max_joined_block_size_rows 65628 --max_threads 2 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 91 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 37526821 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method io_uring --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 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 24 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 1796352702 --min_compress_block_size 2432510 --max_compress_block_size 2560469 --merge_tree_compact_parts_min_granules_to_multibuffer_read 124 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 9750889 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Europe/Amsterdam --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.68 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --enable_vertical_final 1 --optimize_extract_common_expressions 0 --use_query_condition_cache 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0 --max_bytes_ratio_before_external_group_by 0
2025-03-19 10:13:03 
2025-03-19 10:13:03 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.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 1 --min_merge_bytes_to_use_direct_io 6269711117 --index_granularity_bytes 869794 --merge_max_block_size 22487 --index_granularity 53966 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 93116 --primary_key_compress_block_size 63450 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 404718844 --compact_parts_max_bytes_to_buffer 451965505 --compact_parts_max_granules_to_buffer 59 --compact_parts_merge_max_bytes_to_prefetch_part 11377385 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 10 --prewarm_mark_cache 0 --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-03-19 10:13:03 
2025-03-19 10:13:03 Database: test_accit017

2025-03-18 23:08:16 Reason: result differs with reference:  
2025-03-18 23:08:16 --- /repo/tests/queries/0_stateless/02941_variant_type_4.reference	2025-03-18 22:53:22.731694170 -0230
2025-03-18 23:08:16 +++ /repo/tests/queries/0_stateless/02941_variant_type_4.stdout	2025-03-18 23:08:16.521818448 -0230
2025-03-18 23:08:16 @@ -26,11 +26,11 @@
2025-03-18 23:08:16  MergeTree wide
2025-03-18 23:08:16  test6 insert
2025-03-18 23:08:16  test6 select
2025-03-18 23:08:16 -1000000
2025-03-18 23:08:16 -200000
2025-03-18 23:08:16 -200000
2025-03-18 23:08:16 +999999
2025-03-18 23:08:16 +200001
2025-03-18 23:08:16  200000
2025-03-18 23:08:16  200000
2025-03-18 23:08:16 +199999
2025-03-18 23:08:16  -----------------------------------------------------------------------------------------------------------
2025-03-18 23:08:16  test6 select
2025-03-18 23:08:16  1000000
2025-03-18 23:08:16 
2025-03-18 23:08:16 
2025-03-18 23:08:16 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 445754 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 1667997 --max_read_buffer_size 655952 --prefer_localhost_replica 1 --max_block_size 76528 --max_joined_block_size_rows 26769 --max_threads 2 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 2 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 29958600 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 6306728742 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --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 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 22 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 459490918 --min_compress_block_size 1204339 --max_compress_block_size 1529414 --merge_tree_compact_parts_min_granules_to_multibuffer_read 75 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 2073348 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.04 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 0 --optimize_extract_common_expressions 0 --use_query_condition_cache 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.2 --max_bytes_ratio_before_external_group_by 0.0
2025-03-18 23:08:16 
2025-03-18 23:08:16 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 864649747 --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 1 --index_granularity_bytes 12413591 --merge_max_block_size 2608 --index_granularity 18281 --min_bytes_for_wide_part 990527795 --marks_compress_block_size 49440 --primary_key_compress_block_size 68492 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 516300830 --compact_parts_max_bytes_to_buffer 127472132 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 28783911 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 280 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 0
2025-03-18 23:08:16 
2025-03-18 23:08:16 Database: test_lk0y27l0