Skip to content

Flaky test: 00944_minmax_nan #97217

@KochetovNicolai

Description

@KochetovNicolai

Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.

Test name: 00944_minmax_nan
Failure reason: result differs with reference
CI report: Stateless tests (amd_asan, distributed plan, parallel, 1/2)

Failing test history: cidb

Test output:

2026-02-14 00:48:42 Reason: result differs with reference:  
2026-02-14 00:48:42 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00944_minmax_nan.reference	2026-02-14 00:31:29.025931032 +0600
2026-02-14 00:48:42 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00944_minmax_nan.stdout	2026-02-14 00:48:42.482706824 +0600
2026-02-14 00:48:42 @@ -1,21 +1,21 @@
2026-02-14 00:48:42  NaN comparison
2026-02-14 00:48:42  0
2026-02-14 00:48:42  7
2026-02-14 00:48:42  0
2026-02-14 00:48:42  7
2026-02-14 00:48:42  2
2026-02-14 00:48:42  5
2026-02-14 00:48:42  MinMax index should skip all granules for column = NaN comparison
2026-02-14 00:48:42  Description: minmax GRANULARITY 1
2026-02-14 00:48:42  Parts: 0/1
2026-02-14 00:48:42 -Granules: 0/1
2026-02-14 00:48:42 +Granules: 0/7
2026-02-14 00:48:42  Description: minmax GRANULARITY 1
2026-02-14 00:48:42  Parts: 0/1
2026-02-14 00:48:42 -Granules: 0/1
2026-02-14 00:48:42 +Granules: 0/7
2026-02-14 00:48:42  MinMax index should use all granules for column <> NaN comparison
2026-02-14 00:48:42  Description: minmax GRANULARITY 1
2026-02-14 00:48:42  Parts: 1/1
2026-02-14 00:48:42 -Granules: 1/1
2026-02-14 00:48:42 +Granules: 7/7
2026-02-14 00:48:42  Description: minmax GRANULARITY 1
2026-02-14 00:48:42  Parts: 1/1
2026-02-14 00:48:42 -Granules: 1/1
2026-02-14 00:48:42 +Granules: 7/7
2026-02-14 00:48:42 
2026-02-14 00:48:42 
2026-02-14 00:48:42 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 21089314 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 8254463 --max_read_buffer_size 968836 --prefer_localhost_replica 1 --max_block_size 11754 --max_joined_block_size_rows 71542 --joined_block_split_single_row 1 --join_output_by_rowlist_perkey_rows_threshold 30 --max_threads 2 --optimize_append_index 1 --use_hedged_requests 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --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 70 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 25018186 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --distributed_cache_discard_connection_if_unread_data 0 --distributed_cache_use_clients_cache_for_write 1 --distributed_cache_use_clients_cache_for_read 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --enable_filesystem_cache 1 --enable_filesystem_cache_on_write_operations 0 --compile_expressions 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 31 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 677521977 --min_compress_block_size 417426 --max_compress_block_size 2143529 --merge_tree_compact_parts_min_granules_to_multibuffer_read 64 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 5212199 --http_wait_end_of_query True --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 0 --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 True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.55 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --enable_vertical_final 0 --optimize_extract_common_expressions 1 --use_async_executor_for_materialized_views 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 0 --use_skip_indexes_if_final 1 --use_skip_indexes_on_data_read 1 --optimize_rewrite_like_perfect_affix 1 --input_format_parquet_use_native_reader_v3 1 --enable_lazy_columns_replication 1 --allow_special_serialization_kinds_in_output_formats 0 --short_circuit_function_evaluation_for_nulls_threshold 0.5782263149812601 --automatic_parallel_replicas_mode 0 --temporary_files_buffer_size 1036835 --query_plan_optimize_join_order_algorithm dpsize,greedy --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.17 --use_skip_indexes_if_final_exact_mode 1
2026-02-14 00:48:42 
2026-02-14 00:48:42 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 9321699781 --vertical_merge_algorithm_min_rows_to_activate 422769 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 3735427 --merge_max_block_size 8049 --index_granularity 1 --min_bytes_for_wide_part 462028936 --marks_compress_block_size 99307 --primary_key_compress_block_size 69974 --replace_long_file_name_to_hash 1 --max_file_name_length 58 --min_bytes_for_full_part_storage 173662398 --compact_parts_max_bytes_to_buffer 434085824 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 19583862 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 480 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --enable_block_number_column 1 --enable_block_offset_column 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 --object_serialization_version v2 --object_shared_data_serialization_version map_with_buckets --object_shared_data_serialization_version_for_zero_level_parts map_with_buckets --object_shared_data_buckets_for_compact_part 15 --object_shared_data_buckets_for_wide_part 4 --dynamic_serialization_version v2 --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version allow_sparse --enable_shared_storage_snapshot_in_query 1 --min_columns_to_activate_adaptive_write_buffer 696 --reduce_blocking_parts_sleep_ms 686 --shared_merge_tree_outdated_parts_group_size 1 --shared_merge_tree_max_outdated_parts_to_process_at_once 2
2026-02-14 00:48:42 
2026-02-14 00:48:42 Database: test_oti97sja

Metadata

Metadata

Assignees

Labels

flaky testflaky test found by CItestingSpecial 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