Skip to content

Flaky test: 03702_alter_column_update_and_delete_with_secondary_index_drop #93958

@davenger

Description

@davenger

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 ~~~~~

Metadata

Metadata

Assignees

Labels

flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions