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 a4632ab6140 Remove db scenario non standard table structure (#30241)
a4632ab6140 is described below
commit a4632ab6140698b3e4950df4f66169caa8c65bb9
Author: niu niu <[email protected]>
AuthorDate: Fri Feb 23 14:37:39 2024 +0800
Remove db scenario non standard table structure (#30241)
* Remove db scenario non standard table structure
* Annotate non-standard table test case
---
.../resources/cases/dml/dml-integration-insert.xml | 15 ++++++++------
.../resources/cases/dml/dml-integration-update.xml | 6 +++---
.../dql/dql-integration-select-expression.xml | 6 ++++--
.../cases/dql/dql-integration-select-join.xml | 10 ++++++----
.../cases/dql/dql-integration-select-sub-query.xml | 2 +-
.../resources/cases/dql/dql-integration-select.xml | 10 ++++++----
.../resources/cases/rql/rql-integration-count.xml | 3 ++-
.../resources/cases/rql/rql-integration-show.xml | 6 ++++--
.../env/scenario/db/data/actual/dataset.xml | 23 ----------------------
.../db/data/actual/init-sql/h2/01-actual-init.sql | 3 ---
.../data/actual/init-sql/h2/actual-db_0-init.sql | 2 --
.../data/actual/init-sql/mysql/01-actual-init.sql | 11 -----------
.../actual/init-sql/opengauss/01-actual-init.sql | 22 ---------------------
.../actual/init-sql/postgresql/01-actual-init.sql | 22 ---------------------
.../env/scenario/db/data/expected/dataset.xml | 14 -------------
.../data/expected/init-sql/h2/01-expected-init.sql | 6 ------
.../expected/init-sql/mysql/01-expected-init.sql | 3 ---
.../init-sql/opengauss/01-expected-init.sql | 6 ------
.../init-sql/postgresql/01-expected-init.sql | 6 ------
.../init-sql/sqlserver/01-expected-init.sql | 3 ---
20 files changed, 35 insertions(+), 144 deletions(-)
diff --git
a/test/e2e/sql/src/test/resources/cases/dml/dml-integration-insert.xml
b/test/e2e/sql/src/test/resources/cases/dml/dml-integration-insert.xml
index 8fc26a5dd02..e0eb93f550c 100644
--- a/test/e2e/sql/src/test/resources/cases/dml/dml-integration-insert.xml
+++ b/test/e2e/sql/src/test/resources/cases/dml/dml-integration-insert.xml
@@ -128,22 +128,25 @@
<assertion parameters="1:int, 1:int, 2:int, 2:int"
expected-data-file="batch_insert_without_generate_key_column.xml"
expected-generated-key-data-file="batch_insert_without_generate_key_column_generated_key_data.xml"
/>
</test-case>
- <test-case sql="INSERT INTO t_broadcast_table(id, status) values (?,
'insert'),(?, 'insert')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="INSERT INTO t_broadcast_table(id, status) values (?,
'insert'),(?, 'insert')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="2:int, 3:int"
expected-data-file="batch_insert_into_broadcast_table.xml" />
- </test-case>
+ </test-case>-->
<!--fixme! issue #9769-->
<!-- <test-case sql="INSERT INTO t_single_table(single_id, id, status)
values (?, ?, 'insert'),(?, ?, 'insert')"
db-types="MySQL,SQLServer,PostgreSQL,Oracle"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
<!-- <assertion parameters="5:int, 5000:int, 6:int, 6000:int"
expected-data-file="batch_insert_into_single_table.xml" />-->
<!-- </test-case>-->
- <test-case sql="INSERT INTO t_single_table (single_id, id, status) VALUES
(?, ?, 'insert'), (?, ?, 'insert')" db-types="MySQL"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="INSERT INTO t_single_table (single_id, id, status)
VALUES (?, ?, 'insert'), (?, ?, 'insert')" db-types="MySQL"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="5:int, 5000:int, 6:int, 6000:int"
expected-data-file="batch_insert_with_auto_generate_key_column.xml" />
- </test-case>
+ </test-case>-->
- <test-case sql="INSERT INTO t_single_table (id, status) VALUES (?,
'insert'), (?, 'insert')" db-types="MySQL"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="INSERT INTO t_single_table (id, status) VALUES (?,
'insert'), (?, 'insert')" db-types="MySQL"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="5000:int, 6000:int"
expected-data-file="batch_insert_without_auto_generate_key_column.xml"
expected-generated-key-data-file="batch_insert_without_auto_generate_key_column_generated_key_data.xml"
/>
- </test-case>
+ </test-case>-->
<test-case sql="INSERT INTO t_user (user_id, user_name, password, email,
telephone, creation_date) VALUES (?, ?, '123456', '[email protected]',
'12341234123', '2018-08-08'), (?, ?, '23456', '[email protected]', '23452345456',
'2019-08-08')" scenario-types="encrypt" db-types="MySQL,PostgreSQL,openGauss">
<assertion parameters="40:int, tomas:String, 41:int, mike:String"
expected-data-file="batch_insert_into_user_table.xml" />
diff --git
a/test/e2e/sql/src/test/resources/cases/dml/dml-integration-update.xml
b/test/e2e/sql/src/test/resources/cases/dml/dml-integration-update.xml
index d1345c00736..797113a77f0 100644
--- a/test/e2e/sql/src/test/resources/cases/dml/dml-integration-update.xml
+++ b/test/e2e/sql/src/test/resources/cases/dml/dml-integration-update.xml
@@ -45,10 +45,10 @@
<assertion expected-data-file="update_with_column_equal_column.xml" />
</test-case>
- <!-- TODO FIXED ME PostgreSQL return 0 -->
- <test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'"
db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO FIXED ME PostgreSQL return 0 and replace with standard table
structure -->
+ <!--<test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'"
db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion expected-data-file="update_broadcast_table.xml" />
- </test-case>
+ </test-case>-->
<!--fixme! issue #9769-->
<!-- <test-case sql="UPDATE t_single_table s SET s.status = 'finished'"
db-types="MySQL,SQLServer,PostgreSQL,Oracle"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
diff --git
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-expression.xml
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-expression.xml
index f0df5c20240..6f0c42e2488 100644
---
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-expression.xml
+++
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-expression.xml
@@ -111,11 +111,13 @@
<assertion parameters="1000:int"
expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT n.nspname as "Schema", c.relname as
"Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view'
WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN
'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN
'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM
pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_name [...]
+ <!-- TODO add db scenario when use standard table -->
+ <test-case sql="SELECT n.nspname as "Schema", c.relname as
"Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view'
WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN
'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN
'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM
pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_name [...]
<assertion expected-data-file="select_sys_data_for_pg.xml" />
</test-case>
- <test-case sql="SELECT n.nspname as "Schema", c.relname as
"Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view'
WHEN 'i' THEN 'index' WHEN 'I' THEN 'global partition index' WHEN 'S' THEN
'sequence' WHEN 'L' THEN 'large sequence' WHEN 'f' THEN 'foreign table' WHEN
'm' THEN 'materialized view' WHEN 'e' THEN 'stream' WHEN 'o' THEN 'contview'
END as "Type", pg_catalog.pg_get_userbyid(c.relowner) as
"Owner", c.reloptions as "Stora [...]
+ <!-- TODO add db scenario when use standard table -->
+ <test-case sql="SELECT n.nspname as "Schema", c.relname as
"Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view'
WHEN 'i' THEN 'index' WHEN 'I' THEN 'global partition index' WHEN 'S' THEN
'sequence' WHEN 'L' THEN 'large sequence' WHEN 'f' THEN 'foreign table' WHEN
'm' THEN 'materialized view' WHEN 'e' THEN 'stream' WHEN 'o' THEN 'contview'
END as "Type", pg_catalog.pg_get_userbyid(c.relowner) as
"Owner", c.reloptions as "Stora [...]
<assertion expected-data-file="select_sys_data_for_og.xml" />
</test-case>
diff --git
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-join.xml
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-join.xml
index 5fa9912fb4e..8c545f239be 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-join.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-join.xml
@@ -37,9 +37,10 @@
<assertion parameters="1000:int, 1100:int, 11:int"
expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id
= i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status =
c.status WHERE (o.order_id = ? OR o.order_id = ?) AND o.user_id = ? AND
o.status = ?" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON
o.status = c.status WHERE (o.order_id = ? OR o.order_id = ?) AND o.user_id = ?
AND o.status = ?" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="1000:int, 1100:int, 11:int, init:String"
expected-data-source-name="read_dataset" />
- </test-case>
+ </test-case>-->
<test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id
= i.user_id AND o.order_id = i.order_id ORDER BY i.item_id"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-source-name="read_dataset" />
@@ -81,10 +82,11 @@
<assertion parameters="10:int, 19:int, 1000:int, 1909:int, 1:int,
10:int" expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id
= i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status =
c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND o.status
= ? ORDER BY i.item_id" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON
o.status = c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ?
AND o.status = ? ORDER BY i.item_id"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="10:int, 11:int, 1001:int, 1100:int,
init:String" expected-data-source-name="read_dataset" />
<assertion parameters="10:int, 11:int, 1009:int, 1108:int,
none:String" expected-data-source-name="read_dataset" />
- </test-case>
+ </test-case>-->
<test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i
USING(order_id) WHERE o.order_id = ?" db-types="MySQL,PostgreSQL"
scenario-types="tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion parameters="1000:int"
expected-data-source-name="read_dataset" />
diff --git
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-sub-query.xml
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-sub-query.xml
index 35f84918662..94ff238c42f 100644
---
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-sub-query.xml
+++
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-sub-query.xml
@@ -54,7 +54,7 @@
<assertion parameters="1200:int"
expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM (SELECT count(*) as count, id from
t_single_table group by id) as temp_table" db-types="MySQL" scenario-types="db">
+ <test-case sql="SELECT * FROM (SELECT count(*) as count, user_id from
t_user group by user_id) as temp_table" db-types="MySQL" scenario-types="db">
<assertion expected-data-source-name="read_dataset" />
</test-case>
diff --git
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
index ecc2745bc0f..2d80a0016d0 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select.xml
@@ -68,9 +68,10 @@
<assertion parameters="12:int, 1000:int"
expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM t_broadcast_table"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="SELECT * FROM t_broadcast_table"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion expected-data-source-name="read_dataset" />
- </test-case>
+ </test-case>-->
<!-- TODO add
dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting
scenario when use standard t_user table in issue#21286 -->
<test-case sql="SELECT * FROM t_user WHERE user_id <= 15 ORDER BY
user_id" scenario-types="encrypt">
@@ -92,9 +93,10 @@
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM t_single_table"
db-types="MySQL,Oracle,SQLServer"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <!-- TODO Replace with standard table structure -->
+ <!--<test-case sql="SELECT * FROM t_single_table"
db-types="MySQL,Oracle,SQLServer"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-source-name="read_dataset" />
- </test-case>
+ </test-case>-->
<!-- TODO Replace with standard table structure -->
<!--<test-case sql="SELECT o.*, i.* FROM t_order_federate o,
t_order_item_federate i WHERE o.order_id = ? AND i.item_id = ?"
scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
diff --git
a/test/e2e/sql/src/test/resources/cases/rql/rql-integration-count.xml
b/test/e2e/sql/src/test/resources/cases/rql/rql-integration-count.xml
index 699131faaeb..b0f758e78ea 100644
--- a/test/e2e/sql/src/test/resources/cases/rql/rql-integration-count.xml
+++ b/test/e2e/sql/src/test/resources/cases/rql/rql-integration-count.xml
@@ -17,7 +17,8 @@
-->
<integration-test-cases>
- <test-case sql="COUNT SINGLE TABLE"
scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <!-- TODO add db scenario when use standard table -->
+ <test-case sql="COUNT SINGLE TABLE"
scenario-types="tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="count_single_table.xml" />
</test-case>
diff --git a/test/e2e/sql/src/test/resources/cases/rql/rql-integration-show.xml
b/test/e2e/sql/src/test/resources/cases/rql/rql-integration-show.xml
index e962cfd5afd..5e0b44cdf6d 100644
--- a/test/e2e/sql/src/test/resources/cases/rql/rql-integration-show.xml
+++ b/test/e2e/sql/src/test/resources/cases/rql/rql-integration-show.xml
@@ -95,11 +95,13 @@
<assertion expected-data-file="show_single_table_rules.xml" />
</test-case>
- <test-case sql="SHOW SINGLE TABLE t_single_table"
scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <!-- TODO add db scenario when use standard table -->
+ <test-case sql="SHOW SINGLE TABLE t_single_table"
scenario-types="tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="show_single_table.xml" />
</test-case>
- <test-case sql="SHOW SINGLE TABLES"
scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <!-- TODO add db scenario when use standard table -->
+ <test-case sql="SHOW SINGLE TABLES"
scenario-types="tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="show_single_tables.xml" />
</test-case>
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/dataset.xml
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/dataset.xml
index c15e427bac3..2659279c292 100644
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/dataset.xml
+++ b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/dataset.xml
@@ -75,15 +75,6 @@
<column name="continent_name" type="varchar" />
<column name="creation_date" type="datetime" />
</metadata>
- <metadata data-nodes="db_0.t_single_table">
- <column name="single_id" type="numeric" />
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
- <metadata data-nodes="db_${0..9}.t_broadcast_table">
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
<row data-node="db_0.t_order" values="1000, 10, init, null, test,
2017-08-08" />
<row data-node="db_0.t_order" values="1001, 10, init, 2, test, 2017-08-08"
/>
<row data-node="db_0.t_order" values="2000, 20, init, null, test,
2017-08-08" />
@@ -454,18 +445,4 @@
<row data-node="db_8.t_country" values="86, china, asia, 2017-08-08" />
<row data-node="db_9.t_country" values="1, usa, north america, 2017-08-08"
/>
<row data-node="db_9.t_country" values="86, china, asia, 2017-08-08" />
- <row data-node="db_0.t_single_table" values="1, 1000, init" />
- <row data-node="db_0.t_single_table" values="2, 1101, init" />
- <row data-node="db_0.t_single_table" values="3, 2300, init" />
- <row data-node="db_0.t_single_table" values="4, 2401, init" />
- <row data-node="db_0.t_broadcast_table" values="1, init" />
- <row data-node="db_1.t_broadcast_table" values="1, init" />
- <row data-node="db_2.t_broadcast_table" values="1, init" />
- <row data-node="db_3.t_broadcast_table" values="1, init" />
- <row data-node="db_4.t_broadcast_table" values="1, init" />
- <row data-node="db_5.t_broadcast_table" values="1, init" />
- <row data-node="db_6.t_broadcast_table" values="1, init" />
- <row data-node="db_7.t_broadcast_table" values="1, init" />
- <row data-node="db_8.t_broadcast_table" values="1, init" />
- <row data-node="db_9.t_broadcast_table" values="1, init" />
</dataset>
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
index b5738f68768..a8fdb8c5338 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
@@ -19,13 +19,10 @@ DROP TABLE IF EXISTS t_order CASCADE;
DROP TABLE IF EXISTS t_order_item CASCADE;
DROP TABLE IF EXISTS t_product_category CASCADE;
DROP TABLE IF EXISTS t_country CASCADE;
-DROP TABLE IF EXISTS t_broadcast_table CASCADE;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
index 4184efba50d..4f4865dab06 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
@@ -17,8 +17,6 @@
DROP TABLE IF EXISTS t_user CASCADE;
DROP TABLE IF EXISTS t_product CASCADE;
-DROP TABLE IF EXISTS t_single_table CASCADE;
CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11)
NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50)
NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50)
NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
index 34cd6cc32ba..4f204fd42a3 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
@@ -46,8 +46,6 @@ CREATE TABLE db_0.t_user (user_id INT PRIMARY KEY, user_name
VARCHAR(50) NOT NUL
CREATE TABLE db_0.t_product (product_id INT PRIMARY KEY, product_name
VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status
VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE db_0.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_0.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_0.t_single_table (single_id INT NOT NULL AUTO_INCREMENT, id
INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id), UNIQUE KEY (id,
status));
-CREATE TABLE db_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_0.t_order (order_id);
CREATE TABLE db_1.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
@@ -56,61 +54,52 @@ CREATE TABLE db_1.t_merchant (merchant_id INT PRIMARY KEY,
country_id SMALLINT N
CREATE TABLE db_1.t_product_detail (detail_id INT PRIMARY KEY, product_id INT
NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE db_1.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_1.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_1.t_order (order_id);
CREATE TABLE db_2.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_2.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_2.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_2.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_2.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_2.t_order (order_id);
CREATE TABLE db_3.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_3.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_3.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_3.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_3.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_3.t_order (order_id);
CREATE TABLE db_4.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_4.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_4.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_4.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_4.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_4.t_order (order_id);
CREATE TABLE db_5.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_5.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_5.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_5.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_5.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_5.t_order (order_id);
CREATE TABLE db_6.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_6.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_6.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_6.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_6.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_6.t_order (order_id);
CREATE TABLE db_7.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_7.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_7.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_7.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_7.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_7.t_order (order_id);
CREATE TABLE db_8.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_8.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_8.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_8.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_8.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_8.t_order (order_id);
CREATE TABLE db_9.t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_9.t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE db_9.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE db_9.t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE db_9.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON db_9.t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/opengauss/01-actual-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/opengauss/01-actual-init.sql
index ce4b248dbbb..fad044bb043 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/opengauss/01-actual-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/opengauss/01-actual-init.sql
@@ -45,8 +45,6 @@ DROP TABLE IF EXISTS t_user;
DROP TABLE IF EXISTS t_product;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_single_table;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -54,8 +52,6 @@ CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name
VARCHAR(50) NOT NULL, pa
CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50)
NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50)
NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-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_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_1;
@@ -66,7 +62,6 @@ DROP TABLE IF EXISTS t_merchant;
DROP TABLE IF EXISTS t_product_detail;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -74,7 +69,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY,
country_id SMALLINT NOT NU
CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT
NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_2;
@@ -83,13 +77,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_3;
@@ -98,13 +90,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_4;
@@ -113,13 +103,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_5;
@@ -128,13 +116,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_6;
@@ -143,13 +129,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_7;
@@ -158,13 +142,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_8;
@@ -173,13 +155,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_9;
@@ -188,11 +168,9 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
index 6c4188ff0eb..74aa7fc7631 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -45,8 +45,6 @@ DROP TABLE IF EXISTS t_user;
DROP TABLE IF EXISTS t_product;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_single_table;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -54,8 +52,6 @@ CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name
VARCHAR(50) NOT NULL, pa
CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50)
NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50)
NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-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_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_1;
@@ -66,7 +62,6 @@ DROP TABLE IF EXISTS t_merchant;
DROP TABLE IF EXISTS t_product_detail;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -74,7 +69,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY,
country_id SMALLINT NOT NU
CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT
NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_2;
@@ -83,13 +77,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_3;
@@ -98,13 +90,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_4;
@@ -113,13 +103,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_5;
@@ -128,13 +116,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_6;
@@ -143,13 +129,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_7;
@@ -158,13 +142,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_8;
@@ -173,13 +155,11 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c db_9;
@@ -188,11 +168,9 @@ DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/dataset.xml
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/dataset.xml
index 740f13b08a5..672484520b1 100644
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/dataset.xml
+++ b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/dataset.xml
@@ -75,15 +75,6 @@
<column name="continent_name" type="varchar" />
<column name="creation_date" type="datetime" />
</metadata>
- <metadata data-nodes="expected_dataset.t_single_table">
- <column name="single_id" type="numeric" />
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
- <metadata data-nodes="expected_dataset.t_broadcast_table">
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
<row data-node="expected_dataset.t_order" values="1000, 10, init, null,
test, 2017-08-08" />
<row data-node="expected_dataset.t_order" values="1001, 10, init, 2, test,
2017-08-08" />
<row data-node="expected_dataset.t_order" values="2000, 20, init, null,
test, 2017-08-08" />
@@ -310,9 +301,4 @@
<row data-node="expected_dataset.t_product_category" values="14, car, 13,
2, 2017-08-08" />
<row data-node="expected_dataset.t_country" values="1, usa, north america,
2017-08-08" />
<row data-node="expected_dataset.t_country" values="86, china, asia,
2017-08-08" />
- <row data-node="expected_dataset.t_single_table" values="1, 1000, init" />
- <row data-node="expected_dataset.t_single_table" values="2, 1101, init" />
- <row data-node="expected_dataset.t_single_table" values="3, 2300, init" />
- <row data-node="expected_dataset.t_single_table" values="4, 2401, init" />
- <row data-node="expected_dataset.t_broadcast_table" values="1, init" />
</dataset>
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
index bdf453f4f3d..b5d9380d446 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
@@ -23,9 +23,6 @@ DROP TABLE IF EXISTS t_product CASCADE;
DROP TABLE IF EXISTS t_product_detail CASCADE;
DROP TABLE IF EXISTS t_product_category CASCADE;
DROP TABLE IF EXISTS t_country CASCADE;
--- TODO replace these tables with standard tables
-DROP TABLE IF EXISTS t_single_table CASCADE;
-DROP TABLE IF EXISTS t_broadcast_table CASCADE;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -35,8 +32,5 @@ CREATE TABLE t_product (product_id INT PRIMARY KEY,
product_name VARCHAR(50) NOT
CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT
NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-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_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
index fccd5b6ef6f..1f910f32271 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
@@ -29,8 +29,5 @@ CREATE TABLE expected_dataset.t_product (product_id INT
PRIMARY KEY, product_nam
CREATE TABLE expected_dataset.t_product_detail (detail_id INT PRIMARY KEY,
product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE
NOT NULL);
CREATE TABLE expected_dataset.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE expected_dataset.t_country (country_id SMALLINT PRIMARY KEY,
country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT
NULL);
--- TODO replace these tables with standard tables
-CREATE TABLE expected_dataset.t_single_table (single_id INT NOT NULL
AUTO_INCREMENT, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY
(single_id), UNIQUE KEY (id, status));
-CREATE TABLE expected_dataset.t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON expected_dataset.t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/opengauss/01-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/opengauss/01-expected-init.sql
index a459d0085d5..e40a76ac64f 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/opengauss/01-expected-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/opengauss/01-expected-init.sql
@@ -30,9 +30,6 @@ DROP TABLE IF EXISTS t_product;
DROP TABLE IF EXISTS t_product_detail;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
--- TODO replace these tables with standard tables
-DROP TABLE IF EXISTS t_single_table;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -42,8 +39,5 @@ CREATE TABLE t_product (product_id INT PRIMARY KEY,
product_name VARCHAR(50) NOT
CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT
NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-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_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
index c2432c9655e..c4fdb54ab45 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -30,9 +30,6 @@ DROP TABLE IF EXISTS t_product;
DROP TABLE IF EXISTS t_product_detail;
DROP TABLE IF EXISTS t_product_category;
DROP TABLE IF EXISTS t_country;
--- TODO replace these tables with standard tables
-DROP TABLE IF EXISTS t_single_table;
-DROP TABLE IF EXISTS t_broadcast_table;
CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL,
status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT
NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL,
creation_date DATE NOT NULL);
@@ -42,8 +39,5 @@ CREATE TABLE t_product (product_id INT PRIMARY KEY,
product_name VARCHAR(50) NOT
CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT
NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name
VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL,
creation_date DATE NOT NULL);
CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-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_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
index 35211de83d7..05e5390a48d 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
+++
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -26,8 +26,5 @@ CREATE TABLE expected_dataset.t_product (product_id INT
PRIMARY KEY, product_nam
CREATE TABLE expected_dataset.t_product_detail (detail_id INT PRIMARY KEY,
product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE
NOT NULL);
CREATE TABLE expected_dataset.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
CREATE TABLE expected_dataset.t_country (country_id SMALLINT PRIMARY KEY,
country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT
NULL);
--- TODO replace these tables with standard tables
-CREATE TABLE expected_dataset.t_single_table (single_id INT NOT NULL, id INT
NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE expected_dataset.t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON expected_dataset.t_order (order_id);
