You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2022/11/20 08:38:32 UTC
[shardingsphere] branch master updated: Add IT cases for MySQL integer data types (#22263)
This is an automated email from the ASF dual-hosted git repository.
panjuan 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 6f4528e8b70 Add IT cases for MySQL integer data types (#22263)
6f4528e8b70 is described below
commit 6f4528e8b70b034a2577a0976f60c5f013eb607b
Author: 吴伟杰 <wu...@apache.org>
AuthorDate: Sun Nov 20 16:38:25 2022 +0800
Add IT cases for MySQL integer data types (#22263)
---
.../test/integration/cases/value/SQLValue.java | 3 +++
.../shardingsphere/test/integration/engine/BatchITCase.java | 2 +-
.../mysql/insert_max_values_into_single_table_integer.xml} | 13 ++++++++-----
.../mysql/insert_min_values_into_single_table_integer.xml} | 13 ++++++++-----
.../insert_negative_smallint_into_single_table_integer.xml} | 13 ++++++++-----
.../insert_negative_values_into_single_table_integer.xml} | 13 ++++++++-----
.../test/resources/cases/dml/dml-integration-test-cases.xml | 8 ++++++++
.../cases/rql/dataset/tbl/count_single_table_rule.xml | 2 +-
.../resources/cases/rql/dataset/tbl/show_single_tables.xml | 1 +
.../test/resources/env/scenario/tbl/data/actual/dataset.xml | 7 +++++++
.../scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql | 1 +
.../tbl/data/actual/init-sql/mysql/01-actual-init.sql | 1 +
.../tbl/data/actual/init-sql/opengauss/01-actual-init.sql | 1 +
.../tbl/data/actual/init-sql/postgresql/01-actual-init.sql | 1 +
.../resources/env/scenario/tbl/data/expected/dataset.xml | 7 +++++++
.../tbl/data/expected/init-sql/h2/01-expected-init.sql | 1 +
.../tbl/data/expected/init-sql/mysql/01-expected-init.sql | 1 +
.../data/expected/init-sql/opengauss/01-expected-init.sql | 1 +
.../data/expected/init-sql/postgresql/01-expected-init.sql | 1 +
19 files changed, 68 insertions(+), 22 deletions(-)
diff --git a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/cases/value/SQLValue.java b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/cases/value/SQLValue.java
index 3d8d14d12b3..e665f13ef96 100644
--- a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/cases/value/SQLValue.java
+++ b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/cases/value/SQLValue.java
@@ -51,7 +51,10 @@ public final class SQLValue {
case "varchar":
case "char":
return value;
+ case "tinyint":
+ return Byte.parseByte(value);
case "smallint":
+ return Short.parseShort(value);
case "int":
return Integer.parseInt(value);
case "long":
diff --git a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BatchITCase.java b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BatchITCase.java
index 753e1bd16bc..2fa6a288084 100644
--- a/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BatchITCase.java
+++ b/test/integration-test/test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BatchITCase.java
@@ -130,7 +130,7 @@ public abstract class BatchITCase extends BaseITCase {
}
private void sortRow(final DataSet dataSet) {
- dataSet.getRows().sort(Comparator.comparingInt(o -> Integer.parseInt(o.splitValues(",").get(0))));
+ dataSet.getRows().sort(Comparator.comparingLong(o -> Long.parseLong(o.splitValues(",").get(0))));
}
private void assertDataSet(final PreparedStatement actualPreparedStatement, final List<DataSetRow> expectedDataSetRows, final DataSetMetaData expectedDataSetMetaData) throws SQLException {
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
similarity index 64%
copy from test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
index 366d068001d..4f93ac6ede2 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_max_values_into_single_table_integer.xml
@@ -15,10 +15,13 @@
~ limitations under the License.
-->
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
+<dataset update-count="1">
+ <metadata data-nodes="tbl.t_single_table_integer">
+ <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 values="t_single_table| tbl" />
+ <row data-node="tbl.t_single_table_integer" values="9223372036854775807, 2147483647, 8388607, 32767, 127" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
similarity index 64%
copy from test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
index 366d068001d..7f858b5de36 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_min_values_into_single_table_integer.xml
@@ -15,10 +15,13 @@
~ limitations under the License.
-->
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
+<dataset update-count="1">
+ <metadata data-nodes="tbl.t_single_table_integer">
+ <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 values="t_single_table| tbl" />
+ <row data-node="tbl.t_single_table_integer" values="-9223372036854775808, -2147483648, -8388608, 0, -128" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
similarity index 66%
copy from test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
index 366d068001d..ae559f0ef45 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_smallint_into_single_table_integer.xml
@@ -15,10 +15,13 @@
~ limitations under the License.
-->
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
+<dataset update-count="1">
+ <metadata data-nodes="tbl.t_single_table_integer">
+ <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 values="t_single_table| tbl" />
+ <row data-node="tbl.t_single_table_integer" values="0, 0, 0, -1, 0" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
similarity index 66%
copy from test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
copy to test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
index 366d068001d..c9609557eb8 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dataset/tbl/mysql/insert_negative_values_into_single_table_integer.xml
@@ -15,10 +15,13 @@
~ limitations under the License.
-->
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
+<dataset update-count="1">
+ <metadata data-nodes="tbl.t_single_table_integer">
+ <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 values="t_single_table| tbl" />
+ <row data-node="tbl.t_single_table_integer" values="-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 70a74b180d4..32e2668f43b 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
@@ -289,4 +289,12 @@
<test-case sql="DELETE FROM t_shadow WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow,sharding_encrypt_shadow,encrypt_shadow,readwrite_splitting_and_shadow,sharding_and_shadow">
<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" />
+ <!-- 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" />-->
+ </test-case>
</integration-test-cases>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/count_single_table_rule.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/count_single_table_rule.xml
index 7913d252c80..4cae2d07a0f 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/count_single_table_rule.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/count_single_table_rule.xml
@@ -21,5 +21,5 @@
<column name="database"/>
<column name="count"/>
</metadata>
- <row values="single_table| tbl| 1"/>
+ <row values="single_table| tbl| 2"/>
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
index 366d068001d..c2bb9e24995 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/tbl/show_single_tables.xml
@@ -21,4 +21,5 @@
<column name="resource_name" />
</metadata>
<row values="t_single_table| tbl" />
+ <row values="t_single_table_integer| tbl" />
</dataset>
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 9b819ef2211..ca9a5c83d10 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
@@ -37,6 +37,13 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
+ <metadata data-nodes="tbl.t_single_table_integer">
+ <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>
<metadata data-nodes="tbl.t_broadcast_table">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
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 b8c15f1415e..323ab8286b1 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,3 +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);
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 34ae2e4038d..62fd9f42a76 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,3 +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);
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 d8a08e8713c..3f92f48e38a 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,3 +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);
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 d8a08e8713c..3f92f48e38a 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,3 +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);
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 d6e0104ea0b..ff74f58c5ed 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
@@ -37,6 +37,13 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
+ <metadata data-nodes="expected_dataset.t_single_table_integer">
+ <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>
<metadata data-nodes="expected_dataset.t_broadcast_table">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
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 8b8618a68f1..7ba26834f6f 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,5 +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 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 6efde829beb..02d5a4634f1 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,5 +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 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 7b5fa2a077a..09f8856482d 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,3 +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);
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 7b5fa2a077a..09f8856482d 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,3 +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);