Flaky test: 03734_has_function_key_condition_skip_index #93162
Description
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: 03734_has_function_key_condition_skip_index
Failure reason: result differs with reference
CI report: Stateless tests (amd_debug, AsyncInsert, s3 storage, parallel)
CIDB statistics: cidb
Test output:
2025-12-23 15:20:10 Reason: result differs with reference:
2025-12-23 15:20:10 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03734_has_function_key_condition_skip_index.reference 2025-12-23 15:00:29.828408607 +0000
2025-12-23 15:20:10 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03734_has_function_key_condition_skip_index.stdout 2025-12-23 15:20:10.557996682 +0000
2025-12-23 15:20:10 @@ -22,27 +22,27 @@
2025-12-23 15:20:10 WHERE has([5432, 7432, 9999], key_col);
2025-12-23 15:20:10 Expression ((Project names + Projection))
2025-12-23 15:20:10 Aggregating
2025-12-23 15:20:10 Expression (Before GROUP BY)
2025-12-23 15:20:10 Filter ((WHERE + Change column names to column identifiers))
2025-12-23 15:20:10 ReadFromMergeTree (default.test_has_skip_minmax)
2025-12-23 15:20:10 Indexes:
2025-12-23 15:20:10 PrimaryKey
2025-12-23 15:20:10 Condition: true
2025-12-23 15:20:10 Parts: 1/1
2025-12-23 15:20:10 - Granules: 100/100
2025-12-23 15:20:10 + Granules: 150/150
2025-12-23 15:20:10 Skip
2025-12-23 15:20:10 Name: idx_key_minmax
2025-12-23 15:20:10 Description: minmax GRANULARITY 4
2025-12-23 15:20:10 Parts: 1/1
2025-12-23 15:20:10 - Granules: 80/100
2025-12-23 15:20:10 - Ranges: 5
2025-12-23 15:20:10 + Granules: 106/150
2025-12-23 15:20:10 + Ranges: 10
2025-12-23 15:20:10 SELECT count()
2025-12-23 15:20:10 FROM test_has_skip_minmax
2025-12-23 15:20:10 WHERE has([5432, 7432, 9999], key_col);
2025-12-23 15:20:10 30
2025-12-23 15:20:10 SELECT count()
2025-12-23 15:20:10 FROM test_has_skip_minmax
2025-12-23 15:20:10 WHERE key_col IN [5432, 7432, 9999];
2025-12-23 15:20:10 30
2025-12-23 15:20:10 DROP TABLE IF EXISTS test_has_skip_set;
2025-12-23 15:20:10 CREATE TABLE test_has_skip_set (
2025-12-23 15:20:10 @@ -108,25 +108,25 @@
2025-12-23 15:20:10 WHERE has(['v_12345', 'v_54321', 'v_99999'], key_str);
2025-12-23 15:20:10 Expression ((Project names + Projection))
2025-12-23 15:20:10 Aggregating
2025-12-23 15:20:10 Expression (Before GROUP BY)
2025-12-23 15:20:10 Filter ((WHERE + Change column names to column identifiers))
2025-12-23 15:20:10 ReadFromMergeTree (default.test_has_skip_bloom)
2025-12-23 15:20:10 Indexes:
2025-12-23 15:20:10 PrimaryKey
2025-12-23 15:20:10 Condition: true
2025-12-23 15:20:10 Parts: 1/1
2025-12-23 15:20:10 - Granules: 100/100
2025-12-23 15:20:10 + Granules: 228/228
2025-12-23 15:20:10 Skip
2025-12-23 15:20:10 Name: idx_key_bf
2025-12-23 15:20:10 Description: bloom_filter GRANULARITY 4
~~~~~ truncated 19 lines ~~~~~