-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Test 03210_variant_with_aggregate_function_type inconsistent select order (on rare occasions?) #72008
Copy link
Copy link
Closed
Labels
testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
2024-11-16 01:13:37 Reason: result differs with reference:
2024-11-16 01:13:37 --- /repo/tests/queries/0_stateless/03210_variant_with_aggregate_function_type.reference 2024-11-16 00:55:49.097664463 +0100
2024-11-16 01:13:37 +++ /repo/tests/queries/0_stateless/03210_variant_with_aggregate_function_type.stdout 2024-11-16 01:13:37.887710806 +0100
2024-11-16 01:13:37 @@ -1,5 +1,5 @@
2024-11-16 01:13:37 - 500
2024-11-16 01:13:37 fail 500
2024-11-16 01:13:37 + 500
2024-11-16 01:13:37 499
2024-11-16 01:13:37 fail 500
2024-11-16 01:13:37 500 499
2024-11-16 01:13:37
2024-11-16 01:13:37
2024-11-16 01:13:37 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 5538951 --max_read_buffer_size 1020725 --prefer_localhost_replica 0 --max_block_size 61953 --max_joined_block_size_rows 65639 --max_threads 2 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 16 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 5292409 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 3935742678 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --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 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 29 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2665313932 --min_compress_block_size 1524013 --max_compress_block_size 92318 --merge_tree_compact_parts_min_granules_to_multibuffer_read 63 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4071566 --http_wait_end_of_query True --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 0 --session_timezone Europe/Paris --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.93 --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 0 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --output_format_native_write_json_as_string 0 --enable_vertical_final 0
2024-11-16 01:13:37
2024-11-16 01:13:37 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 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 25065774 --merge_max_block_size 21231 --index_granularity 61783 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 24704 --primary_key_compress_block_size 37095 --replace_long_file_name_to_hash 0 --max_file_name_length 108 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 182592949 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 15228452 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 169
2024-11-16 01:13:37
2024-11-16 01:13:37 Database: test_df8ufnii
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI