🌚🌞

ClickHouse Stateful Tests (release) for PR #807

Test nameTest statusTest time, sec.
2025-05-24 01:24:29 --- /usr/share/clickhouse-test/queries/1_stateful/00088_global_in_one_shard_and_rows_before_limit.reference	2025-05-24 01:15:26.188706275 +0300
2025-05-24 01:24:29 +++ /tmp/clickhouse-test/1_stateful/00088_global_in_one_shard_and_rows_before_limit.stdout	2025-05-24 01:24:29.702893054 +0300
2025-05-24 01:24:29 @@ -13,11 +13,11 @@
2025-05-24 01:24:29  
2025-05-24 01:24:29  	"data":
2025-05-24 01:24:29  	[
2025-05-24 01:24:29 -		["2014-03-17", "1406958"],
2025-05-24 01:24:29 -		["2014-03-18", "1383658"],
2025-05-24 01:24:29 -		["2014-03-19", "1405797"],
2025-05-24 01:24:29 -		["2014-03-20", "1353623"],
2025-05-24 01:24:29 -		["2014-03-21", "1245779"]
2025-05-24 01:24:29 +		["2014-03-17", "1391806"],
2025-05-24 01:24:29 +		["2014-03-18", "1368943"],
2025-05-24 01:24:29 +		["2014-03-19", "1388315"],
2025-05-24 01:24:29 +		["2014-03-20", "1337345"],
2025-05-24 01:24:29 +		["2014-03-21", "1228982"]
2025-05-24 01:24:29  	],
2025-05-24 01:24:29  
2025-05-24 01:24:29  	"rows": 5,
2025-05-24 01:24:29 
2025-05-24 01:24:29 
2025-05-24 01:24:29 Settings used in the test: --max_insert_threads 5 --group_by_two_level_threshold 1000000 --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 18528691 --max_read_buffer_size 845075 --prefer_localhost_replica 0 --max_block_size 79636 --max_threads 5 --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 33 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 42268386 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 1 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1456472386 --min_compress_block_size 1081767 --max_compress_block_size 1594615 --merge_tree_compact_parts_min_granules_to_multibuffer_read 115 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 2196097 --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 0 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --prefer_warmed_unmerged_parts_seconds 3 --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.25
2025-05-24 01:24:29 
2025-05-24 01:24:29 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.8881523052926201 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --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 27272997 --merge_max_block_size 16360 --index_granularity 59678 --min_bytes_for_wide_part 549260993 --marks_compress_block_size 90339 --primary_key_compress_block_size 85212 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --mi
This test passed. Update analyzer_tech_debt.txt.
00177_memory_bound_merging OK 1.0
00176_bson_parallel_parsing SKIPPED 0.0
00176_distinct_limit_by_limit_bug_43377 OK 0.1
00175_counting_resources_in_subqueries OK 0.19
00178_quantile_ddsketch OK 1.41
00175_obfuscator_schema_inference OK 0.88
00174_distinct_in_order OK 0.82
00173_group_by_use_nulls OK 0.53
00172_early_constant_folding OK 0.11
00171_grouping_aggregated_transform_bug OK 0.44
00169_contingency OK 2.2
00167_read_bytes_from_fs OK 1.34
00167_parallel_parsing_with_names_and_types OK 3.24
00166_explain_estimate OK 0.08
00165_jit_aggregate_functions OK 0.58
00164_quantileBfloat16 OK 0.94
00163_column_oriented_formats OK 1.63
00162_mmap_compression_none OK 1.62
00161_parallel_parsing_with_names OK 1.43
00160_decode_xml_component OK 0.19
00172_hits_joins OK 20.34
00159_parallel_formatting_http OK 1.83
00159_parallel_formatting_json_and_friends_1 OK 8.72
00159_parallel_formatting_tsv_and_friends OK 3.81
00159_parallel_formatting_csv_and_friends OK 7.01
00156_max_execution_speed_sample_merge OK 4.33
00154_avro OK 0.32
00159_parallel_formatting_json_and_friends_2 OK 6.94
00151_order_by_read_in_order OK 0.11
00153_aggregate_arena_race OK 0.18
00150_quantiles_timing_precision OK 0.2
00149_quantiles_timing_distributed OK 0.48
00148_monotonic_functions_and_index OK 0.38
00147_global_in_aggregate_function OK 0.75
00146_aggregate_function_uniq OK 0.7
00144_functions_of_aggregation_states OK 0.15
00145_aggregate_functions_statistics OK 0.24
00142_system_columns OK 0.07
00143_transform_non_const_default OK 0.18
00141_transform OK 0.08
00098_primary_key_memory_allocated OK 0.1
00097_constexpr_in_index OK 0.09
00139_like OK 0.4
00095_hyperscan_profiler OK 0.35
00096_obfuscator_save_load OK 0.65
00094_order_by_array_join_limit OK 0.42
00093_prewhere_array_join OK 0.48
00092_obfuscator OK 0.59
00091_prewhere_two_conditions OK 1.2
00089_position_functions_with_non_constant_arg OK 2.3
00090_thread_pool_deadlock OK 3.31
00087_where_0 OK 0.08
00086_array_reduce OK 0.13
00085_monotonic_evaluation_segfault OK 0.52
00083_array_filter OK 0.24
00082_quantiles OK 1.1
00081_group_by_without_key_and_totals OK 0.18
00084_external_aggregation OK 3.92
00079_array_join_not_used_joined_column OK 0.37
00080_array_join_and_union OK 2.9
00077_log_tinylog_stripelog OK 2.08
00076_system_columns_bytes OK 0.07
00075_left_array_join OK 0.26
00074_full_join OK 7.12
00073_uniq_array OK 0.08
00071_merge_tree_optimize_aio OK 0.45
00069_duplicate_aggregation_keys OK 0.09
00068_subquery_in_prewhere OK 0.09
00072_compare_date_and_string_index OK 0.84
00067_union_all OK 0.11
00066_sorting_distributed_many_replicas OK 0.05
00065_loyalty_with_storage_join OK 0.71
00062_loyalty OK 0.95
00061_storage_buffer OK 0.39
00060_move_to_prewhere_and_sets OK 0.09
00059_merge_sorting_empty_array_joined OK 0.06
00056_view OK 0.22
00055_index_and_not OK 0.11
00054_merge_tree_partitions OK 0.28
00063_loyalty_joins OK 4.25
00053_replicate_segfault OK 1.54
00051_min_max_array OK 0.27
00052_group_by_in OK 0.58
00050_min_max OK 0.15
00048_min_max OK 0.13
00049_max_string_if OK 0.19
00047_bar OK 0.14
00046_uniq_upto_distributed OK 1.84
00045_uniq_upto OK 2.04
00043_any_left_join OK 0.4
00042_any_left_join OK 0.64
00041_aggregating_materialized_view OK 0.92
00040_aggregating_materialized_view OK 0.41
00039_primary_key OK 0.08
00038_uniq_state_merge2 OK 0.26
00037_uniq_state_merge1 OK 0.23
00036_aggregate_hashed OK 0.61
00035_aggregate_keys128 OK 0.08
00034_aggregate_key_fixed_string OK 0.13
00033_aggregate_key_string OK 0.5
00032_aggregate_key64 OK 0.12
00031_array_enumerate_uniq OK 0.12
00030_array_enumerate_uniq OK 0.2
00024_random_counters OK 8.37
00044_any_left_join_string OK 13.92
00023_totals_limit OK 0.41
00021_2_select_with_in OK 0.07
00022_merge_prewhere OK 0.09
00021_3_select_with_in OK 0.08
00021_1_select_with_in OK 0.07
00017_aggregation_uninitialized_memory OK 0.09
00016_any_if_distributed_cond_always_false OK 0.17
00015_totals_and_no_aggregate_functions OK 0.12
00014_filtering_arrays OK 0.12
00013_sorting_of_nested OK 0.8
00012_sorting_distributed OK 0.15
00011_sorting OK 0.12
00010_quantiles_segfault OK 0.19
00009_uniq_distributed OK 0.21
00008_uniq OK 0.15
00007_uniq OK 0.07
00006_agregates OK 0.08
00005_filtering OK 0.14
00004_top_counters OK 0.16
00002_count_visits OK 0.09
00001_count_hits OK 0.1
00020_distinct_order_by_distributed OK 2.96
00180_no_seek_avoiding_when_reading_from_cache OK 9.6
00170_s3_cache OK 3.58
00158_cache_dictionary_has OK 54.01
00157_cache_dictionary OK 144.34
00152_insert_different_granularity OK 0.47
00140_rename OK 0.71