You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2022/11/22 07:07:06 UTC
[shardingsphere] branch master updated: Add IT cases to cover PostgreSQL/openGauss integer types (#22335)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 4b13a889505 Add IT cases to cover PostgreSQL/openGauss integer types (#22335)
4b13a889505 is described below
commit 4b13a88950558d448dfa41424c5777bbf019c3ed
Author: 吴伟杰 <wu...@apache.org>
AuthorDate: Tue Nov 22 15:06:59 2022 +0800
Add IT cases to cover PostgreSQL/openGauss integer types (#22335)
---
.../insert_max_values_into_single_table_integer.xml | 3 ++-
.../insert_min_values_into_single_table_integer.xml | 3 ++-
...insert_negative_values_into_single_table_integer.xml} | 3 ++-
.../insert_min_values_into_single_table_integer.xml | 3 ++-
...nsert_negative_smallint_into_single_table_integer.xml | 3 ++-
.../insert_negative_values_into_single_table_integer.xml | 3 ++-
.../resources/cases/dml/dml-integration-test-cases.xml | 16 +++++++++++-----
.../resources/env/scenario/tbl/data/actual/dataset.xml | 1 +
.../tbl/data/actual/init-sql/h2/01-actual-init.sql | 2 +-
.../tbl/data/actual/init-sql/mysql/01-actual-init.sql | 2 +-
.../data/actual/init-sql/opengauss/01-actual-init.sql | 2 +-
.../data/actual/init-sql/postgresql/01-actual-init.sql | 2 +-
.../resources/env/scenario/tbl/data/expected/dataset.xml | 1 +
.../tbl/data/expected/init-sql/h2/01-expected-init.sql | 2 +-
.../data/expected/init-sql/mysql/01-expected-init.sql | 2 +-
.../expected/init-sql/opengauss/01-expected-init.sql | 2 +-
.../expected/init-sql/postgresql/01-expected-init.sql | 2 +-
17 files changed, 33 insertions(+), 19 deletions(-)
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_max_values_into_single_table_integer.xml
similarity index 88%
copy from test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_max_values_into_single_table_integer.xml
index 4f93ac6ede2..1aad1926f60 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_max_values_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="9223372036854775807, 2147483647, 8388607, 32767, 127" />
+ <row data-node="tbl.t_single_table_integer" values="1, 9223372036854775807, 2147483647, 8388607, 32767, 127" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_min_values_into_single_table_integer.xml
similarity index 88%
copy from test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_min_values_into_single_table_integer.xml
index 7f858b5de36..757ffb8c600 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_min_values_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="-9223372036854775808, -2147483648, -8388608, 0, -128" />
+ <row data-node="tbl.t_single_table_integer" values="2, -9223372036854775808, -2147483648, -8388608, 0, 0" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_negative_values_into_single_table_integer.xml
similarity index 90%
rename from test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
rename to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_negative_values_into_single_table_integer.xml
index 4f93ac6ede2..94243af2506 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/insert_negative_values_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="9223372036854775807, 2147483647, 8388607, 32767, 127" />
+ <row data-node="tbl.t_single_table_integer" values="3, -1, -1, -1, 0, 0" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
index 7f858b5de36..ea54617ed70 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="-9223372036854775808, -2147483648, -8388608, 0, -128" />
+ <row data-node="tbl.t_single_table_integer" values="2, -9223372036854775808, -2147483648, -8388608, 0, -128" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
index ae559f0ef45..91b02503257 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="0, 0, 0, -1, 0" />
+ <row data-node="tbl.t_single_table_integer" values="4, 0, 0, 0, -1, 0" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
index c9609557eb8..813918db1f1 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
@@ -17,11 +17,12 @@
<dataset update-count="1">
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
<column name="col_smallint" type="numeric" />
<column name="col_tinyint" type="numeric" />
</metadata>
- <row data-node="tbl.t_single_table_integer" values="-1, -1, -1, 0, -1" />
+ <row data-node="tbl.t_single_table_integer" values="3, -1, -1, -1, 0, -1" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
index 32e2668f43b..ab8368d59c2 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
@@ -290,11 +290,17 @@
<assertion parameters="0:int, 4:int, 5:int" expected-data-file="shadow_delete_order_by_user_id.xml" />
</test-case>
- <test-case sql="INSERT INTO t_single_table_integer (col_bigint, col_int, col_mediumint, col_smallint, col_tinyint) values (?, ?, ?, ?, ?)" db-types="MySQL" scenario-types="tbl">
- <assertion parameters="9223372036854775807:long, 2147483647:int, 8388607:int, 32767:smallint, 127:tinyint" expected-data-file="insert_max_values_into_single_table_integer.xml" />
+ <test-case sql="INSERT INTO t_single_table_integer (id, col_bigint, col_int, col_mediumint, col_smallint, col_tinyint) values (?, ?, ?, ?, ?, ?)" db-types="MySQL" scenario-types="tbl">
+ <assertion parameters="1:int, 9223372036854775807:long, 2147483647:int, 8388607:int, 32767:smallint, 127:tinyint" expected-data-file="insert_max_values_into_single_table_integer.xml" />
<!-- TODO Support negative value of smallint & tinyint. https://github.com/apache/shardingsphere/issues/21902 -->
- <assertion parameters="-9223372036854775808:long, -2147483648:int, -8388608:int, 0:smallint, -128:tinyint" expected-data-file="insert_min_values_into_single_table_integer.xml" />
- <assertion parameters="-1:long, -1:int, -1:int, 0:smallint, -1:tinyint" expected-data-file="insert_negative_values_into_single_table_integer.xml" />
- <!-- <assertion parameters="0:int, 0:int, 0:int, -1:smallint, 0:int" expected-data-file="insert_negative_smallint_into_single_table_integer.xml" />-->
+ <assertion parameters="2:int, -9223372036854775808:long, -2147483648:int, -8388608:int, 0:smallint, -128:tinyint" expected-data-file="insert_min_values_into_single_table_integer.xml" />
+ <assertion parameters="3:int, -1:long, -1:int, -1:int, 0:smallint, -1:tinyint" expected-data-file="insert_negative_values_into_single_table_integer.xml" />
+ <!-- <assertion parameters="4:int, 0:int, 0:int, 0:int, -1:smallint, 0:int" expected-data-file="insert_negative_smallint_into_single_table_integer.xml" />-->
+ </test-case>
+ <test-case sql="INSERT INTO t_single_table_integer (id, col_bigint, col_int, col_mediumint, col_smallint, col_tinyint) values (?, ?, ?, ?, ?, ?)" db-types="PostgreSQL,openGauss" scenario-types="tbl">
+ <assertion parameters="1:int, 9223372036854775807:long, 2147483647:int, 8388607:int, 32767:smallint, 127:tinyint" expected-data-file="insert_max_values_into_single_table_integer.xml" />
+ <!-- TODO Support negative value of smallint(int2). https://github.com/apache/shardingsphere/issues/22334 -->
+ <assertion parameters="2:int, -9223372036854775808:long, -2147483648:int, -8388608:int, 0:smallint, 0:tinyint" expected-data-file="insert_min_values_into_single_table_integer.xml" />
+ <assertion parameters="3:int, -1:long, -1:int, -1:int, 0:smallint, 0:tinyint" expected-data-file="insert_negative_values_into_single_table_integer.xml" />
</test-case>
</integration-test-cases>
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/dataset.xml b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/dataset.xml
index ca9a5c83d10..32228e8e35f 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/dataset.xml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/dataset.xml
@@ -38,6 +38,7 @@
<column name="status" type="varchar" />
</metadata>
<metadata data-nodes="tbl.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql
index 323ab8286b1..08e6a5643a3 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql
@@ -89,4 +89,4 @@ CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
index 62fd9f42a76..296e6027398 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
@@ -69,4 +69,4 @@ CREATE INDEX order_index_t_order_9 ON tbl.t_order_9 (order_id);
CREATE TABLE tbl.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE tbl.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE tbl.t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
+CREATE TABLE tbl.t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/opengauss/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/opengauss/01-actual-init.sql
index 3f92f48e38a..24d39f3c787 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/opengauss/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/opengauss/01-actual-init.sql
@@ -95,4 +95,4 @@ CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
index 3f92f48e38a..24d39f3c787 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -95,4 +95,4 @@ CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/dataset.xml b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/dataset.xml
index ff74f58c5ed..24989df3c11 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/dataset.xml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/dataset.xml
@@ -38,6 +38,7 @@
<column name="status" type="varchar" />
</metadata>
<metadata data-nodes="expected_dataset.t_single_table_integer">
+ <column name="id" type="numeric" />
<column name="col_bigint" type="numeric" />
<column name="col_int" type="numeric" />
<column name="col_mediumint" type="numeric" />
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql
index 7ba26834f6f..bd67829a4b0 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql
@@ -28,6 +28,6 @@ CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VAR
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
CREATE TABLE t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
index 02d5a4634f1..0bdce6ea30d 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
@@ -27,6 +27,6 @@ CREATE TABLE expected_dataset.t_single_table (single_id INT NOT NULL, id INT NOT
CREATE TABLE expected_dataset.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE TABLE expected_dataset.t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
CREATE TABLE expected_dataset.t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
-CREATE TABLE expected_dataset.t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
+CREATE TABLE expected_dataset.t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint MEDIUMINT NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint TINYINT NOT NULL);
CREATE INDEX order_index_t_order ON expected_dataset.t_order (order_id);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/opengauss/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/opengauss/01-expected-init.sql
index 09f8856482d..b37c0725ed8 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/opengauss/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/opengauss/01-expected-init.sql
@@ -37,4 +37,4 @@ CREATE TABLE t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id
CREATE TABLE t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
CREATE INDEX order_index_t_order ON t_order (order_id);
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
index 09f8856482d..b37c0725ed8 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -37,4 +37,4 @@ CREATE TABLE t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id
CREATE TABLE t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
CREATE INDEX order_index_t_order ON t_order (order_id);
-CREATE TABLE t_single_table_integer (col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);
+CREATE TABLE t_single_table_integer (id INT PRIMARY KEY, col_bigint BIGINT NOT NULL, col_int INT NOT NULL, col_mediumint INT4 NOT NULL, col_smallint SMALLINT NOT NULL, col_tinyint INT2 NOT NULL);