【测试类型：工具功能】【测试版本：master】mysql在线对具有任意形式唯一约束的复合分区表create index，opengauss侧迁移失败

【标题描述】:mysql在线对具有任意形式唯一约束的复合分区表create index，opengauss侧迁移失败(唯一约束包括unique、primary key)

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/110334_df26937a_10781039.png "屏幕截图.png")
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:

【测试类型】:

【数据库版本】(查询命令: gaussdb –V):
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/110346_20c02053_10781039.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/110401_e8fd9709_10781039.png "屏幕截图.png")
【预置条件】:
MySQL5.7.37已安装，opengauss3.0.0已安装，pg_chameleon已安装并且可用
【操作步骤】(请填写详细的操作步骤):
1.开启在线迁移
chameleon start_replica --config config-example --source mysql
2.MySQL侧建表，创建索引
create table t_chameleon_ddl_3520 (
    id int unique,
    first_name varchar(30),
    last_name varchar(30),
	col4 date
) partition by list(id) 
    subpartition by hash(id)
    subpartitions 3 
(
    partition p0 values in (11,31),
    partition p1 values in (21,41)
);
create index i_chameleon_ddl_3520 on t_chameleon_ddl_3520(id);

create table t_chameleon_ddl_3523 (
    id int auto_increment primary key,
    first_name varchar(30),
    last_name varchar(30),
	col4 date
) partition by list(id) 
    subpartition by hash(id)
    subpartitions 3
(
    partition p0 values in (11,31),
    partition p1 values in (21,41)
);
create index i_chameleon_ddl_3523 on t_chameleon_ddl_3523(id);

create table t_chameleon_ddl_3526 (
    id int primary key,
    first_name varchar(30),
    last_name varchar(30),
	col4 date
) partition by list(id) 
    subpartition by hash(id)
    subpartitions 3
(
    partition p0 values in (11,31),
    partition p1 values in (21,41)
);
create index i_chameleon_ddl_3526 on t_chameleon_ddl_3526(id);
3.opengauss侧查询
\d t_chameleon_ddl_3520
\d t_chameleon_ddl_3523
\d t_chameleon_ddl_3526
【预期输出】:

【实际输出】:
1.开启在线迁移成功
2.MySQL建表成功，创建索引成功
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/111001_50a3d233_10781039.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/110843_67b2479a_10781039.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/110916_33db0ddd_10781039.png "屏幕截图.png")
3.opengauss侧未查询到表
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/111115_1b232a12_10781039.png "屏幕截图.png")
【原因分析】:

【日志信息】(请附上日志文件、截图、coredump信息):
chameleon工具日志报错如下：
![输入图片说明](https://images.gitee.com/uploads/images/2022/0621/111227_6a0fbe0a_10781039.png "屏幕截图.png")
【测试代码】:

openGauss/openGauss-tools-chameleon

内容风险标识

评论 (6)

openGauss/openGauss-tools-chameleon .gitee-modal { width: 500px !important; }

内容风险标识