Materialized view project CI/CD support

[windtalker]

TiDB https://github.com/pingcap/tidb/tree/v8.5.4-20260113-dcad06c
TiKV https://github.com/tikv/tikv/tree/v8.5.4-20260120-d25f155
PD https://github.com/tikv/pd/tree/v8.5.4-20251209-34c6617
TiFlash https://github.com/pingcap/tiflash/tree/v8.5.4
Client-go tikv/client-go@c88e82c
mysql-test https://github.com/PingCAP-QE/tidb-test/commit/c674b0f50f597807aa929add493698bddb456de5
kvproto https://github.com/pingcap/kvproto/tree/97d984880071228de123095a1550a9236e92d224
tikv/copr-test https://github.com/pingcap/tidb/tree/release-8.5

CI: all the existing ci for each repo
CD: classic

[wuhuizuo]

branch to be created: feature/release-8.5-materialized-view

[ti-chi-bot]

Verified branches created for Materialized View CI/CD support:

• pingcap/tidb: feature/release-8.5-materialized-view -> dcad06cdb4a49e2f26610e2f623ce8c52b4b6538
• tikv/tikv: feature/release-8.5-materialized-view -> d25f155da60e90bdb901a784136bc5fd07c1f9cb
• tikv/pd: feature/release-8.5-materialized-view -> 34c66174f57b9f6208dbb959ce48eb0e2a589337
• pingcap/tiflash: feature/release-8.5-materialized-view -> e7d70a34b48e153ee3dc69fbc6191e68bcae9ad3
• tikv/client-go: feature/release-8.5-materialized-view -> c88e82cf292797be5ef3dc3982776c7e9397e57a
• PingCAP-QE/tidb-test: feature/release-8.5-materialized-view -> c674b0f50f597807aa929add493698bddb456de5
• pingcap/kvproto: feature/release-8.5-materialized-view
• tikv/copr-test: feature/release-8.5-materialized-view -> 01453e1ef6c962001fe3e5c174ec0fdc626ba14f

[lybcodes]

pingcap/tidb

ref: pingcap/tidb#66008

ghpr_mysql_test（https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Frelease-8.5%2Fpull_mysql_test/detail/pull_mysql_test/4015/pipeline/）：

1. Error Message Format Mismatch

Many test cases failed because the expected error format is ER_[planner:1451]..., but the actual returned error is in the format Error 1451 (23000): ....
Example (Line 1251):

query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row...)(err: Error 1451 (23000): Cannot delete or update a parent row...)

2. ANALYZE TABLE Output Differences

Multiple tests failed because the output of ANALYZE TABLE contains an extra Warning information.
Expected (Line 2755):

Note    1105    Analyze use auto adjusted sample rate...

Actual (Line 2755):

Note    1105    Analyze use auto adjusted sample rate...
Warning 1105    No predicate column has been collected yet for table ..., so only indexes and the columns composing the indexes will be analyzed

Affected tests:

• func_group (Lines 2755, 3400)
• group_min_max_innodb (Lines 3110, 3401)
• index_merge_bugs (Lines 3174, 3402)
• key_diff (Line 3451)

3. EXPLAIN Output Differences

lead_lag_explain test failed (Line 3518) due to a mismatch in the concurrency value in the EXPLAIN output.
Expected: execution info: concurrency:2
Actual: execution info: concurrency:5

4. Error Type Mismatches

Several tests failed due to mismatched error types:

• lead_lag:49 (Line 3500): Expected ER_PARSE_ERROR, got ErrWrongArguments
• ps:1591 (Line 3510): Expected ER_NO_DB_ERROR, got ErrUnsupportedDDLOperation
• alter_table1:932 (Line 3511): Query succeeded, but expected error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
• alter_table1:935 (Line 3513): Expected ER_INDEX_KEY_LENGTH_EXCEED_THE_LIMIT, got ER_TOO_LONG_KEY
• partition_list:80 (Line 3341): Expected ER_PARSE_ERROR, got ER_PARTITION_COLUMN_LIST_ERROR
• partition_range:23 (Line 3393): Expected ER_NULL_IN_VALUES_LESS_THAN, got ErrFieldTypeNotAllowedAsPartitionField

---

pull_unit_test（https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/release-8.5/job/pull_unit_test/4807/consoleFull）：

Failed Test

1. TestAddGlobalIndexInIngestWithUpdate (Line 2130)
   • Location: //pkg/ddl/ingest:ingest_test (shard 21 of 26)
   • Error (Line 2035):

     Error: Expected nil, but got: [kv:1062]Duplicate entry '14' for key 't.idx'
     

   • Duration: 22.84 seconds
   • Reason:
     Duplicate key value '14' detected when adding a global unique index, violating the uniqueness constraint.

Unstable (Flaky) Tests

The following tests are marked as flaky (unstable, may fail intermittently):

• //pkg/lightning/backend/local:local_test (Line 2638)

  • Reason: Java runtime error SIGBUS (0x7) (Lines 2185-2218)
  • Issue: Bus error occurred during PerfMemory::alloc, possibly due to environment or resource issues.

• //pkg/ddl/ingest:ingest_test (Line 2696)

  • Includes: TestAddGlobalIndexInIngestWithUpdate

• //pkg/session/clusteredindextest:clusteredindextest_test (Line 3358)

  • Reason: Java runtime error SIGBUS (0x7) (Lines 2912-2919)
  • Result: 1 failure out of 4 attempts (Line 12168)

---

[ti-chi-bot]

Added repo: tikv/copr-test\n\n- Created branch: feature/materialized_view (based on release-8.5) -> 01453e1ef6c962001fe3e5c174ec0fdc626ba14f\n

[ti-chi-bot]

tikv/copr-test branch rename:\n\n- Renamed feature/materialized_view -> feature/release-8.5-materialized-view\n- Branch tip unchanged: 01453e1ef6c962001fe3e5c174ec0fdc626ba14f (from release-8.5)\n