Directory listing for /ClickHouse/tests/queries/1_stateful/

• 00001_count_hits.reference
• 00001_count_hits.sql
• 00002_count_visits.reference
• 00002_count_visits.sql
• 00004_top_counters.reference
• 00004_top_counters.sql
• 00005_filtering.reference
• 00005_filtering.sql
• 00006_agregates.reference
• 00006_agregates.sql
• 00007_uniq.reference
• 00007_uniq.sql
• 00008_uniq.reference
• 00008_uniq.sql
• 00009_uniq_distributed.reference
• 00009_uniq_distributed.sql
• 00010_quantiles_segfault.reference
• 00010_quantiles_segfault.sql
• 00011_sorting.reference
• 00011_sorting.sql
• 00012_sorting_distributed.reference
• 00012_sorting_distributed.sql
• 00013_sorting_of_nested.reference
• 00013_sorting_of_nested.sql
• 00014_filtering_arrays.reference
• 00014_filtering_arrays.sql
• 00015_totals_and_no_aggregate_functions.reference
• 00015_totals_and_no_aggregate_functions.sql
• 00016_any_if_distributed_cond_always_false.reference
• 00016_any_if_distributed_cond_always_false.sql
• 00017_aggregation_uninitialized_memory.reference
• 00017_aggregation_uninitialized_memory.sql
• 00020_distinct_order_by_distributed.reference
• 00020_distinct_order_by_distributed.sql
• 00021_1_select_with_in.reference
• 00021_1_select_with_in.sql
• 00021_2_select_with_in.reference
• 00021_2_select_with_in.sql
• 00021_3_select_with_in.reference
• 00021_3_select_with_in.sql
• 00022_merge_prewhere.reference
• 00022_merge_prewhere.sql
• 00023_totals_limit.reference
• 00023_totals_limit.sql
• 00024_random_counters.reference
• 00024_random_counters.sql
• 00030_array_enumerate_uniq.reference
• 00030_array_enumerate_uniq.sql
• 00031_array_enumerate_uniq.reference
• 00031_array_enumerate_uniq.sql
• 00032_aggregate_key64.reference
• 00032_aggregate_key64.sql
• 00033_aggregate_key_string.reference
• 00033_aggregate_key_string.sql
• 00034_aggregate_key_fixed_string.reference
• 00034_aggregate_key_fixed_string.sql
• 00035_aggregate_keys128.reference
• 00035_aggregate_keys128.sql
• 00036_aggregate_hashed.reference
• 00036_aggregate_hashed.sql
• 00037_uniq_state_merge1.reference
• 00037_uniq_state_merge1.sql
• 00038_uniq_state_merge2.reference
• 00038_uniq_state_merge2.sql
• 00039_primary_key.reference
• 00039_primary_key.sql
• 00040_aggregating_materialized_view.reference
• 00040_aggregating_materialized_view.sql
• 00041_aggregating_materialized_view.reference
• 00041_aggregating_materialized_view.sql
• 00042_any_left_join.reference
• 00042_any_left_join.sql
• 00043_any_left_join.reference
• 00043_any_left_join.sql
• 00044_any_left_join_string.reference
• 00044_any_left_join_string.sql
• 00045_uniq_upto.reference
• 00045_uniq_upto.sql
• 00046_uniq_upto_distributed.reference
• 00046_uniq_upto_distributed.sql
• 00047_bar.reference
• 00047_bar.sql
• 00048_min_max.reference
• 00048_min_max.sql
• 00049_max_string_if.reference
• 00049_max_string_if.sql
• 00050_min_max.reference
• 00050_min_max.sql
• 00051_min_max_array.reference
• 00051_min_max_array.sql
• 00052_group_by_in.reference
• 00052_group_by_in.sql
• 00053_replicate_segfault.reference
• 00053_replicate_segfault.sql
• 00054_merge_tree_partitions.reference
• 00054_merge_tree_partitions.sql
• 00055_index_and_not.reference
• 00055_index_and_not.sql
• 00056_view.reference
• 00056_view.sql
• 00059_merge_sorting_empty_array_joined.reference
• 00059_merge_sorting_empty_array_joined.sql
• 00060_move_to_prewhere_and_sets.reference
• 00060_move_to_prewhere_and_sets.sql
• 00061_storage_buffer.reference
• 00061_storage_buffer.sql
• 00062_loyalty.reference
• 00062_loyalty.sql
• 00063_loyalty_joins.reference
• 00063_loyalty_joins.sql
• 00065_loyalty_with_storage_join.reference
• 00065_loyalty_with_storage_join.sql
• 00066_sorting_distributed_many_replicas.reference
• 00066_sorting_distributed_many_replicas.sql
• 00067_union_all.reference
• 00067_union_all.sql
• 00068_subquery_in_prewhere.reference
• 00068_subquery_in_prewhere.sql
• 00069_duplicate_aggregation_keys.reference
• 00069_duplicate_aggregation_keys.sql
• 00071_merge_tree_optimize_aio.reference
• 00071_merge_tree_optimize_aio.sql
• 00072_compare_date_and_string_index.reference
• 00072_compare_date_and_string_index.sql
• 00073_uniq_array.reference
• 00073_uniq_array.sql
• 00074_full_join.reference
• 00074_full_join.sql
• 00075_left_array_join.reference
• 00075_left_array_join.sql
• 00076_system_columns_bytes.reference
• 00076_system_columns_bytes.sql
• 00077_log_tinylog_stripelog.reference
• 00077_log_tinylog_stripelog.sql
• 00078_group_by_arrays.reference
• 00078_group_by_arrays.sql
• 00079_array_join_not_used_joined_column.reference
• 00079_array_join_not_used_joined_column.sql
• 00080_array_join_and_union.reference
• 00080_array_join_and_union.sql
• 00081_group_by_without_key_and_totals.reference
• 00081_group_by_without_key_and_totals.sql
• 00082_quantiles.reference
• 00082_quantiles.sql
• 00083_array_filter.reference
• 00083_array_filter.sql
• 00084_external_aggregation.reference
• 00084_external_aggregation.sql
• 00085_monotonic_evaluation_segfault.reference
• 00085_monotonic_evaluation_segfault.sql
• 00086_array_reduce.reference
• 00086_array_reduce.sql
• 00087_where_0.reference
• 00087_where_0.sql
• 00088_global_in_one_shard_and_rows_before_limit.reference
• 00088_global_in_one_shard_and_rows_before_limit.sql
• 00089_position_functions_with_non_constant_arg.reference
• 00089_position_functions_with_non_constant_arg.sql
• 00090_thread_pool_deadlock.reference
• 00090_thread_pool_deadlock.sh
• 00091_prewhere_two_conditions.reference
• 00091_prewhere_two_conditions.sql
• 00092_obfuscator.reference
• 00092_obfuscator.sh
• 00093_prewhere_array_join.reference
• 00093_prewhere_array_join.sql
• 00094_order_by_array_join_limit.reference
• 00094_order_by_array_join_limit.sql
• 00095_hyperscan_profiler.reference
• 00095_hyperscan_profiler.sql
• 00096_obfuscator_save_load.reference
• 00096_obfuscator_save_load.sh
• 00097_constexpr_in_index.reference
• 00097_constexpr_in_index.sql
• 00098_primary_key_memory_allocated.reference
• 00098_primary_key_memory_allocated.sql
• 00139_like.reference
• 00139_like.sql
• 00140_rename.reference
• 00140_rename.sql
• 00141_transform.reference
• 00141_transform.sql
• 00142_system_columns.reference
• 00142_system_columns.sql
• 00143_transform_non_const_default.reference
• 00143_transform_non_const_default.sql
• 00144_functions_of_aggregation_states.reference
• 00144_functions_of_aggregation_states.sql
• 00145_aggregate_functions_statistics.reference
• 00145_aggregate_functions_statistics.sql
• 00146_aggregate_function_uniq.reference
• 00146_aggregate_function_uniq.sql
• 00147_global_in_aggregate_function.reference
• 00147_global_in_aggregate_function.sql
• 00148_monotonic_functions_and_index.reference
• 00148_monotonic_functions_and_index.sql
• 00149_quantiles_timing_distributed.reference
• 00149_quantiles_timing_distributed.sql
• 00150_quantiles_timing_precision.reference
• 00150_quantiles_timing_precision.sql
• 00151_order_by_read_in_order.reference
• 00151_order_by_read_in_order.sql
• 00152_insert_different_granularity.reference
• 00152_insert_different_granularity.sql
• 00153_aggregate_arena_race.reference
• 00153_aggregate_arena_race.sql
• 00154_avro.reference
• 00154_avro.sql
• 00156_max_execution_speed_sample_merge.reference
• 00156_max_execution_speed_sample_merge.sql
• 00157_cache_dictionary.reference
• 00157_cache_dictionary.sql
• 00158_cache_dictionary_has.reference
• 00158_cache_dictionary_has.sql
• 00159_parallel_formatting_csv_and_friends.reference
• 00159_parallel_formatting_csv_and_friends.sh
• 00159_parallel_formatting_http.reference
• 00159_parallel_formatting_http.sh
• 00159_parallel_formatting_json_and_friends_1.reference
• 00159_parallel_formatting_json_and_friends_1.sh
• 00159_parallel_formatting_json_and_friends_2.reference
• 00159_parallel_formatting_json_and_friends_2.sh
• 00159_parallel_formatting_tsv_and_friends.reference
• 00159_parallel_formatting_tsv_and_friends.sh
• 00160_decode_xml_component.reference
• 00160_decode_xml_component.sql
• 00161_parallel_parsing_with_names.reference
• 00161_parallel_parsing_with_names.sh
• 00162_mmap_compression_none.reference
• 00162_mmap_compression_none.sql
• 00163_column_oriented_formats.reference
• 00163_column_oriented_formats.sh
• 00164_quantileBfloat16.reference
• 00164_quantileBfloat16.sql
• 00165_jit_aggregate_functions.reference
• 00165_jit_aggregate_functions.sql
• 00166_explain_estimate.reference
• 00166_explain_estimate.sql
• 00167_parallel_parsing_with_names_and_types.reference
• 00167_parallel_parsing_with_names_and_types.sh
• 00167_read_bytes_from_fs.reference
• 00167_read_bytes_from_fs.sql
• 00169_contingency.reference
• 00169_contingency.sql
• 00170_s3_cache.reference
• 00170_s3_cache.sql
• 00171_grouping_aggregated_transform_bug.reference
• 00171_grouping_aggregated_transform_bug.sql
• 00172_early_constant_folding.reference
• 00172_early_constant_folding.sql
• 00172_hits_joins.reference.j2
• 00172_hits_joins.sql.j2
• 00173_group_by_use_nulls.reference
• 00173_group_by_use_nulls.sql
• 00174_distinct_in_order.reference
• 00174_distinct_in_order.sql
• 00175_counting_resources_in_subqueries.reference
• 00175_counting_resources_in_subqueries.sql
• 00175_obfuscator_schema_inference.reference
• 00175_obfuscator_schema_inference.sh
• 00176_bson_parallel_parsing.reference
• 00176_bson_parallel_parsing.sh
• 00176_distinct_limit_by_limit_bug_43377.reference
• 00176_distinct_limit_by_limit_bug_43377.sql
• 00177_memory_bound_merging.reference
• 00177_memory_bound_merging.sh
• 00178_quantile_ddsketch.reference
• 00178_quantile_ddsketch.sql
• 00180_no_seek_avoiding_when_reading_from_cache.reference
• 00180_no_seek_avoiding_when_reading_from_cache.sh
• 00181_cross_join_compression.reference
• 00181_cross_join_compression.sql
• 00182_simple_squashing_transform_bug.reference
• 00182_simple_squashing_transform_bug.sql
• 00183_prewhere_conditions_order.reference
• 00183_prewhere_conditions_order.sql