Update 表包含全文索引 / 向量表执行报错 -4007

-- 开启 index merge 功能
alter system set _enable_index_merge = true;

-- 创建包含全文索引的表
create table t2(
  id   bigint primary key,
  c1   int,
  c2   int,
  name varchar(200),
  fulltext key ft_name(name) with parser beng,
  key idx_c1(c1)
);

-- 插入测试数据
insert into t2 values (1, 1, 2, 'hello'), (2, 2, 1, 'hi');

-- 执行更新语句，使用 index merge 提示
update /*+ index_merge(t2 idx_c1 idx_c2) */ t2
   set name = 'world'
 where c1 = 1 or c2 = 2;

[2025-12-15 21:46:47.771744] WDIAG [SQL.OPT] check_das_need_scan_with_domain_id (ob_log_plan.cpp:15852) [78110][T1002_L0_G0][T1002][YB420A6801E8-000645C4F6C5A661-0-0] [lt=0][errcode=-4007] complex query with dml on fulltext index / vector index not supported(ret=-4007)
[2025-12-15 21:46:47.771762] WDIAG check_das_need_scan_with_domain_id (ob_log_plan.cpp:15853) [78110][T1002_L0_G0][T1002][YB420A6801E8-000645C4F6C5A661-0-0] [lt=16][errcode=-4007] complex query with dml on fulltext index is not supported

-- 开启 index merge
alter system set _enable_index_merge = true;

-- 用例1：全文索引表
create table t2(
  id   bigint primary key,
  c1   int,
  c2   int,
  name varchar(200),
  fulltext key ft_name(name) with parser beng,
  key idx_c1(c1),
  key idx_c2(c2)
);
insert into t2 values (1, 1, 2, 'hello'), (2, 2, 1, 'hi');
update /*+ index_merge(t2 idx_c1 idx_c2) */ t2
   set name = 'world'
 where c1 = 1 or c2 = 2;
-- 预期报错：complex query with dml on fulltext index is not supported

-- 用例2：向量索引表
CREATE TABLE t3 (
  id bigint PRIMARY KEY,
  status tinyint,
  vector VECTOR(1024),
  KEY idx_status (status),
  VECTOR KEY idx_vector (vector) WITH (DISTANCE=INNER_PRODUCT, TYPE=HNSW, LIB=VSAG)
);
INSERT INTO t3 VALUES (1, 1, NULL);
UPDATE t3 SET status = 2 WHERE id = 1 AND status = 1;
-- 预期报错：ERROR 1235 (0A000): complex query with dml on fulltext index is not supported

alter system set _enable_index_merge = false;