Environment

• Server Version: 5.7.25 OceanBase seekdb (r) (Built 1-4d09eb37f507038efab0cec13df3ea933de7e3d8 Apr 1 2026)
• Is this an RD-provided temporary version?: No
• Reproducibility: Stable (Consistently Reproducible)
• Platform: Windows

Description

When running the mysqltest case fts_index.create_index_on_mv_table on a Windows system, creating a materialized view fails with error 1210.

Steps to Reproduce

1. Connect to the database using: mysql -uroot -h -P 2881
2. Execute the following SQL statements from the test case:

drop table if exists t;
drop materialized view if exists mvt;
create table t(c1 int  primary key, c2 varchar(20), c3 json, c4 vector(3));
create materialized view mvt(c1, c2, c3, c4) as select c1, c2, c3, c4 from t;

3. The CREATE MATERIALIZED VIEW statement results in error 1210.

Error Screenshot:

Additional Context

• Environment Information: Please provide the connection strings for the problematic tenant and the sys tenant, as well as deployment information. Is the environment preserved for investigation?
• Log Information: Logs are not provided in the original report.
• Note: This issue was reported from an external business context. The classification (e.g., customer feedback, online issue, online incident) should be determined based on the specific impact and stage (pre-production POC, post-production bug, production incident).