Flaky test: 03702_alter_column_update_and_delete_with_secondary_index_drop #93958
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: 03702_alter_column_update_and_delete_with_secondary_index_drop
Failure reason: 03702_alter_column_update_and_delete_with_secondary_index_drop
CI report: Stateless tests (amd_ubsan, parallel)
Failing test history: cidb
Test output:
2026-01-12 09:22:14 Reason: result differs with reference:
2026-01-12 09:22:14 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03702_alter_column_update_and_delete_with_secondary_index_drop.reference 2026-01-12 08:47:42.084312432 -0300
2026-01-12 09:22:14 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03702_alter_column_update_and_delete_with_secondary_index_drop.stdout 2026-01-12 09:22:14.760277252 -0300
2026-01-12 09:22:14 @@ -83,35 +83,35 @@
2026-01-12 09:22:14 EXPLAIN indexes = 1 SELECT count() FROM test_table WHERE value = '3';
2026-01-12 09:22:14 Expression ((Project names + Projection))
2026-01-12 09:22:14 Aggregating
2026-01-12 09:22:14 Expression (Before GROUP BY)
2026-01-12 09:22:14 Filter ((WHERE + Change column names to column identifiers))
2026-01-12 09:22:14 ReadFromMergeTree (default.test_table)
2026-01-12 09:22:14 Indexes:
2026-01-12 09:22:14 MinMax
2026-01-12 09:22:14 Condition: true
2026-01-12 09:22:14 Parts: 1/1
2026-01-12 09:22:14 - Granules: 1/1
2026-01-12 09:22:14 + Granules: 9/9
2026-01-12 09:22:14 Partition
2026-01-12 09:22:14 Condition: true
2026-01-12 09:22:14 Parts: 1/1
2026-01-12 09:22:14 - Granules: 1/1
2026-01-12 09:22:14 + Granules: 9/9
2026-01-12 09:22:14 PrimaryKey
2026-01-12 09:22:14 Condition: true
2026-01-12 09:22:14 Parts: 1/1
2026-01-12 09:22:14 - Granules: 1/1
2026-01-12 09:22:14 + Granules: 9/9
2026-01-12 09:22:14 Skip
2026-01-12 09:22:14 Name: idx_ip_set
2026-01-12 09:22:14 Description: set GRANULARITY 1
2026-01-12 09:22:14 Condition: (value in [\'3\', \'3\'])
2026-01-12 09:22:14 Parts: 1/1
2026-01-12 09:22:14 - Granules: 1/1
2026-01-12 09:22:14 + Granules: 9/9
2026-01-12 09:22:14 Ranges: 1
2026-01-12 09:22:14 SELECT count() FROM test_table WHERE value = '3';
2026-01-12 09:22:14 0
2026-01-12 09:22:14 -- Force a table rewrite. Index should be added back
2026-01-12 09:22:14 OPTIMIZE TABLE test_table FINAL;
2026-01-12 09:22:14 SELECT 'Status after DELETE full table rewrite (should be the same)';
2026-01-12 09:22:14 Status after DELETE full table rewrite (should be the same)
2026-01-12 09:22:14 EXPLAIN indexes = 1 SELECT count() FROM test_table WHERE value = '3';
2026-01-12 09:22:14 Expression ((Project names + Projection))
2026-01-12 09:22:14 Aggregating
2026-01-12 09:22:14 @@ -173,133 +173,133 @@
2026-01-12 09:22:14 EXPLAIN indexes = 1 SELECT count() FROM test_table WHERE value = '2000';
2026-01-12 09:22:14 Expression ((Project names + Projection))
2026-01-12 09:22:14 Aggregating
2026-01-12 09:22:14 Expression (Before GROUP BY)
2026-01-12 09:22:14 Filter ((WHERE + Change column names to column identifiers))
2026-01-12 09:22:14 ReadFromMergeTree (default.test_table)
~~~~~ truncated 147 lines ~~~~~