Skip to content

Test 03210_variant_with_aggregate_function_type inconsistent select order (on rare occasions?) #72008

@yakov-olkhovskiy

Description

@yakov-olkhovskiy

https://s3.amazonaws.com/clickhouse-test-reports/71849/571cf3313669c3a08368db4ed384ca04fcd02773/stateless_tests__ubsan__[2_2].html

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

Metadata

Metadata

Assignees

Labels

testingSpecial issue with list of bugs found by CI

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions