This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.

Welcome To openGauss Community

Hey @zhangxubo , thanks for your contribution to the community.

Bot Usage Manual

I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands.

Contact Guide

If you have any questions, please contact the SIG: StorageEngine, AI, CM, CloudNative, SecurityTechnology, SQLEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zhangzq131, @zjh_hw .

20260805 7.0.0LTSB017自测：

建b库建表，导出

导入：

【回归版本】openGauss 7.0.0-RC3 build 7a39d3ac（7.0.0LTS B017，compiled at 2026-08-05 14:35:47）
【回归日期】20260806
【回归人员】wuchenlong
【回归结论】通过

测试结果

B 兼容库 db_b8356 中按 issue 原始建表语句创建 test100（AUTO_INCREMENT 自增列 + 内联索引 + RANGE 分区）并插入 2 行数据；gs_dump -F p 导出后重建空 B 库，用 gsql 导入成功（CREATE TABLE 无语法错误），表结构与数据完整保留（2 行）。

说明

历史异常：gs_dump 导出的 DDL 在自增列索引处插入分区范围，导致 gsql 导入报语法错误（导出格式无法解析）。
B017 上导出 DDL 已恢复为原始表定义方式（INDEX ... USING btree(id) 保持在表定义内，PARTITION BY RANGE 正常跟随），导入不再报错，异常不再复现。

【回归步骤】

执行 SQL（B 兼容库 db_b8356）：

DROP DATABASE IF EXISTS db_b8356;
CREATE DATABASE db_b8356 DBCOMPATIBILITY 'B';
\c db_b8356

create table test100(
id int AUTO_INCREMENT,
name varchar,
datekey date,
index test100_id_index using btree(id)
)
PARTITION BY RANGE(datekey)
(
	PARTITION p202210 VALUES LESS THAN ('2022-10-01'),
	PARTITION p2022101 VALUES LESS THAN ('2022-11-01')
);

INSERT INTO test100(name, datekey) VALUES ('a', '2022-09-05'), ('b', '2022-10-05');
SELECT count(*) AS cnt FROM test100;

执行结果：

DROP DATABASE
CREATE DATABASE
You are now connected to database "db_b8356" as user "wcl0623".
NOTICE:  CREATE TABLE will create implicit sequence "test100_id_seq" for serial column "test100.id"
CREATE TABLE
INSERT 0 2
 cnt
-----
   2
(1 row)

gs_dump 导出：

gs_dump -p 15600 -U wcl0623 -W 'OpenGauss@123' -F p -f /tmp/repro_8356_dump.sql db_b8356
...
gs_dump[port='15600'][db_b8356][2026-08-06 12:12:13]: dump database db_b8356 successfully

导出 DDL（关键部分，自增列索引未被插入分区范围）：

CREATE TABLE "test100" (
    "id" integer AUTO_INCREMENT NOT NULL,
    "name" "varbinary" COLLATE "pg_catalog"."binary",
    "datekey" date,
    INDEX "test100_id_index" USING "btree" ("id")
) AUTO_INCREMENT = 3
WITH (orientation=row, compression=no, collate=1026)
PARTITION BY RANGE ("datekey")
(
    PARTITION "p202210" VALUES LESS THAN ('2022-10-01'),
    PARTITION "p2022101" VALUES LESS THAN ('2022-11-01')
)
ENABLE ROW MOVEMENT;

重建空 B 库后导入：

DROP DATABASE IF EXISTS db_b8356;
CREATE DATABASE db_b8356 DBCOMPATIBILITY 'B';

gsql -d db_b8356 -p 15600 -r -W 'OpenGauss@123' -f /tmp/repro_8356_dump.sql
SET
... (SET x21)
CREATE TABLE
ALTER TABLE
REVOKE
REVOKE
GRANT
GRANT
total time: 30  ms

校验数据：

select * from test100 order by id;
\d test100

 id | name |  datekey
----+------+------------
  1 | \x61 | 2022-09-05
  2 | \x62 | 2022-10-05
(2 rows)

                     Table "public.test100"
 Column  |    Type     |               Modifiers
---------+-------------+----------------------------------------
 id      | integer     | not null AUTO_INCREMENT
 name    | varbinary   | character set SQL_ASCII collate binary
 datekey | date        |
Indexes:
    "test100_id_index" btree (id) LOCAL TABLESPACE pg_default
Partition By RANGE(datekey)
Number of partitions: 2 (View pg_partition to check each partition range.)