(shardingsphere) branch master updated: Remove dbtbl_with_readwrite_splitting non-standard table (#30368)

duanzhengqiang Fri, 01 Mar 2024 22:13:58 -0800

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 aca7c7e6569 Remove dbtbl_with_readwrite_splitting non-standard table 
(#30368)
aca7c7e6569 is described below

commit aca7c7e656941af799f506cd035df19353a2aeb2
Author: niu niu <[email protected]>
AuthorDate: Sat Mar 2 14:11:58 2024 +0800

    Remove dbtbl_with_readwrite_splitting non-standard table (#30368)
---
 .../resources/cases/rql/rql-integration-count.xml  |  4 +-
 .../resources/cases/rql/rql-integration-show.xml   |  8 ++--
 .../data/actual/dataset.xml                        | 37 ------------------
 .../data/actual/init-sql/h2/01-actual-init.sql     |  2 -
 .../actual/init-sql/h2/actual-read_ds_0-init.sql   |  2 -
 .../actual/init-sql/h2/actual-write_ds_0-init.sql  |  2 -
 .../data/actual/init-sql/mysql/01-actual-init.sql  | 22 -----------
 .../actual/init-sql/opengauss/01-actual-init.sql   | 44 ----------------------
 .../actual/init-sql/postgresql/01-actual-init.sql  | 44 ----------------------
 .../data/expected/dataset.xml                      | 15 --------
 .../data/expected/init-sql/h2/01-expected-init.sql |  5 ---
 .../expected/init-sql/mysql/01-expected-init.sql   |  6 ---
 .../init-sql/opengauss/01-expected-init.sql        | 12 ------
 .../init-sql/postgresql/01-expected-init.sql       | 12 ------
 14 files changed, 6 insertions(+), 209 deletions(-)

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 d8baa44685b..ad9e4968237 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,8 +17,8 @@
   -->
 
 <integration-test-cases>
-    <!-- TODO add db,tbl scenario when use standard table -->
-    <test-case sql="COUNT SINGLE TABLE" 
scenario-types="encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+    <!-- TODO add db,tbl,dbtbl_with_readwrite_splitting scenario when use 
standard table -->
+    <test-case sql="COUNT SINGLE TABLE" 
scenario-types="encrypt,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 0feb71fa6bd..891c86ceb94 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,13 +95,13 @@
         <assertion expected-data-file="show_single_table_rules.xml" />
     </test-case>
     
-    <!-- TODO add db,tbl scenario when use standard table -->
-    <test-case sql="SHOW SINGLE TABLE t_single_table" 
scenario-types="encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+    <!-- TODO add db,tbl,dbtbl_with_readwrite_splitting scenario when use 
standard table -->
+    <test-case sql="SHOW SINGLE TABLE t_single_table" 
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
         <assertion expected-data-file="show_single_table.xml" />
     </test-case>
     
-    <!-- TODO add db,tbl scenario when use standard table -->
-    <test-case sql="SHOW SINGLE TABLES" 
scenario-types="encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+    <!-- TODO add db,tbl,dbtbl_with_readwrite_splitting scenario when use 
standard table -->
+    <test-case sql="SHOW SINGLE TABLES" 
scenario-types="encrypt,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/dbtbl_with_readwrite_splitting/data/actual/dataset.xml
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/dataset.xml
index 4bf57abb749..c1281f38801 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/dataset.xml
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/dataset.xml
@@ -75,19 +75,6 @@
         <column name="continent_name" type="varchar" />
         <column name="creation_date" type="datetime" />
     </metadata>
-    <metadata data-nodes="write_ds_0.t_single_table,read_ds_0.t_single_table">
-        <column name="single_id" type="numeric" />
-        <column name="id" type="numeric" />
-        <column name="status" type="varchar" />
-    </metadata>
-    <metadata 
data-nodes="write_ds_${0..9}.t_broadcast_table,read_ds_${0..9}.t_broadcast_table">
-        <column name="id" type="numeric" />
-        <column name="status" type="varchar" />
-    </metadata>
-    <row data-node="write_ds_0.t_single_table" values="1, 1000, init" />
-    <row data-node="write_ds_0.t_single_table" values="2, 1101, init" />
-    <row data-node="write_ds_0.t_single_table" values="3, 1202, init" />
-    <row data-node="write_ds_0.t_single_table" values="4, 1303, init" />
     <row data-node="write_ds_0.t_order_0" values="1000, 10, init, 1, test, 
2017-08-08" />
     <row data-node="write_ds_0.t_order_1" values="1001, 10, init, 2, test, 
2017-08-08" />
     <row data-node="write_ds_0.t_order_2" values="1002, 10, init, 3, test, 
2017-08-08" />
@@ -628,20 +615,6 @@
     <row data-node="write_ds_8.t_country" values="86, china, asia, 2017-08-08" 
/>
     <row data-node="write_ds_9.t_country" values="1, usa, north america, 
2017-08-08" />
     <row data-node="write_ds_9.t_country" values="86, china, asia, 2017-08-08" 
/>
-    <row data-node="write_ds_0.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_1.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_2.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_3.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_4.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_5.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_6.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_7.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_8.t_broadcast_table" values="1, init" />
-    <row data-node="write_ds_9.t_broadcast_table" values="1, init" />
-    <row data-node="read_ds_0.t_single_table" values="1, 1000, init_read" />
-    <row data-node="read_ds_0.t_single_table" values="2, 1101, init_read" />
-    <row data-node="read_ds_0.t_single_table" values="3, 1202, init_read" />
-    <row data-node="read_ds_0.t_single_table" values="4, 1303, init_read" />
     <row data-node="read_ds_0.t_order_0" values="1000, 10, init_read, 1, test, 
2017-08-08" />
     <row data-node="read_ds_0.t_order_1" values="1001, 10, init_read, 2, test, 
2017-08-08" />
     <row data-node="read_ds_0.t_order_2" values="1002, 10, init_read, 3, test, 
2017-08-08" />
@@ -1182,14 +1155,4 @@
     <row data-node="read_ds_8.t_country" values="86, china, asia, 2017-08-08" 
/>
     <row data-node="read_ds_9.t_country" values="1, usa, north america, 
2017-08-08" />
     <row data-node="read_ds_9.t_country" values="86, china, asia, 2017-08-08" 
/>
-    <row data-node="read_ds_0.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_1.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_2.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_3.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_4.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_5.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_6.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_7.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_8.t_broadcast_table" values="1, init_read" />
-    <row data-node="read_ds_9.t_broadcast_table" values="1, init_read" />
 </dataset>
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
index 8dee30b1218..b4668bb2124 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
@@ -37,7 +37,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -61,7 +60,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id INT 
NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
index c67e2c717da..5ecccd42c02 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
@@ -17,8 +17,6 @@
 
 DROP TABLE IF EXISTS t_user;
 DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_single_table;
 
 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 
VARCHAR(50) 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/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
index c67e2c717da..5ecccd42c02 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
@@ -17,8 +17,6 @@
 
 DROP TABLE IF EXISTS t_user;
 DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_single_table;
 
 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 
VARCHAR(50) 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/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
index d2bee271c09..ec9c59a710d 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
@@ -84,8 +84,6 @@ CREATE TABLE write_ds_0.t_user (user_id INT PRIMARY KEY, 
user_name VARCHAR(50) N
 CREATE TABLE write_ds_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 write_ds_0.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_0.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
-CREATE TABLE write_ds_0.t_single_table (single_id INT NOT NULL AUTO_INCREMENT, 
id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
 CREATE INDEX order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_0.t_order_2 (order_id);
@@ -121,7 +119,6 @@ CREATE TABLE write_ds_1.t_merchant (merchant_id INT PRIMARY 
KEY, country_id INT
 CREATE TABLE write_ds_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 write_ds_1.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_1.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_1.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_1.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_1.t_order_2 (order_id);
@@ -155,7 +152,6 @@ CREATE TABLE write_ds_2.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_2.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_2.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_2.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_2.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_2.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_2.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_2.t_order_2 (order_id);
@@ -189,7 +185,6 @@ CREATE TABLE write_ds_3.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_3.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_3.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_3.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_3.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_3.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_3.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_3.t_order_2 (order_id);
@@ -223,7 +218,6 @@ CREATE TABLE write_ds_4.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_4.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_4.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_4.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_4.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_4.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_4.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_4.t_order_2 (order_id);
@@ -257,7 +251,6 @@ CREATE TABLE write_ds_5.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_5.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_5.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_5.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_5.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_5.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_5.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_5.t_order_2 (order_id);
@@ -291,7 +284,6 @@ CREATE TABLE write_ds_6.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_6.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_6.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_6.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_6.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_6.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_6.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_6.t_order_2 (order_id);
@@ -325,7 +317,6 @@ CREATE TABLE write_ds_7.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_7.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_7.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_7.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_7.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_7.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_7.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_7.t_order_2 (order_id);
@@ -359,7 +350,6 @@ CREATE TABLE write_ds_8.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_8.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_8.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_8.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_8.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_8.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_8.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_8.t_order_2 (order_id);
@@ -393,7 +383,6 @@ CREATE TABLE write_ds_9.t_order_9 (order_id INT PRIMARY 
KEY, user_id INT NOT NUL
 CREATE TABLE write_ds_9.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_9.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_ds_9.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE write_ds_9.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON write_ds_9.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON write_ds_9.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON write_ds_9.t_order_2 (order_id);
@@ -429,8 +418,6 @@ CREATE TABLE read_ds_0.t_user (user_id INT PRIMARY KEY, 
user_name VARCHAR(50) NO
 CREATE TABLE read_ds_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 read_ds_0.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_0.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
-CREATE TABLE read_ds_0.t_single_table (single_id INT NOT NULL AUTO_INCREMENT, 
id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
 CREATE INDEX order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_0.t_order_2 (order_id);
@@ -466,7 +453,6 @@ CREATE TABLE read_ds_1.t_merchant (merchant_id INT PRIMARY 
KEY, country_id INT N
 CREATE TABLE read_ds_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 read_ds_1.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_1.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_1.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_1.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_1.t_order_2 (order_id);
@@ -500,7 +486,6 @@ CREATE TABLE read_ds_2.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_2.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_2.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_2.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_2.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_2.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_2.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_2.t_order_2 (order_id);
@@ -534,7 +519,6 @@ CREATE TABLE read_ds_3.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_3.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_3.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_3.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_3.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_3.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_3.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_3.t_order_2 (order_id);
@@ -568,7 +552,6 @@ CREATE TABLE read_ds_4.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_4.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_4.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_4.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_4.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_4.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_4.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_4.t_order_2 (order_id);
@@ -602,7 +585,6 @@ CREATE TABLE read_ds_5.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_5.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_5.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_5.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_5.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_5.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_5.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_5.t_order_2 (order_id);
@@ -636,7 +618,6 @@ CREATE TABLE read_ds_6.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_6.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_6.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_6.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_6.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_6.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_6.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_6.t_order_2 (order_id);
@@ -670,7 +651,6 @@ CREATE TABLE read_ds_7.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_7.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_7.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_7.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_7.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_7.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_7.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_7.t_order_2 (order_id);
@@ -704,7 +684,6 @@ CREATE TABLE read_ds_8.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_8.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_8.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_8.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_8.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_8.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_8.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_8.t_order_2 (order_id);
@@ -738,7 +717,6 @@ CREATE TABLE read_ds_9.t_order_9 (order_id INT PRIMARY KEY, 
user_id INT NOT NULL
 CREATE TABLE read_ds_9.t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 
NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_9.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_ds_9.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE read_ds_9.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) 
NULL, PRIMARY KEY (id));
 CREATE INDEX order_index_t_order_0 ON read_ds_9.t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON read_ds_9.t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON read_ds_9.t_order_2 (order_id);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
index 9f6761f9a60..4e1037ceb43 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
@@ -83,8 +83,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -110,8 +108,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -149,7 +145,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -175,7 +170,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, 
country_id INT NOT NULL, m
 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -211,7 +205,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -235,7 +228,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -271,7 +263,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -295,7 +286,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -331,7 +321,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -355,7 +344,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -391,7 +379,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -415,7 +402,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -451,7 +437,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -475,7 +460,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -511,7 +495,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -535,7 +518,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -571,7 +553,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -595,7 +576,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -631,7 +611,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -655,7 +634,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -693,8 +671,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_broadcast_table;
-DROP TABLE IF EXISTS t_single_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -720,8 +696,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -759,7 +733,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -785,7 +758,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, 
country_id INT NOT NULL, m
 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -821,7 +793,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -845,7 +816,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -881,7 +851,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -905,7 +874,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -941,7 +909,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -965,7 +932,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1001,7 +967,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1025,7 +990,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1061,7 +1025,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1085,7 +1048,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1121,7 +1083,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1145,7 +1106,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1181,7 +1141,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1205,7 +1164,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1241,7 +1199,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1265,7 +1222,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
index 9f6761f9a60..4e1037ceb43 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -83,8 +83,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -110,8 +108,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -149,7 +145,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -175,7 +170,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, 
country_id INT NOT NULL, m
 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -211,7 +205,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -235,7 +228,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -271,7 +263,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -295,7 +286,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -331,7 +321,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -355,7 +344,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -391,7 +379,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -415,7 +402,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -451,7 +437,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -475,7 +460,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -511,7 +495,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -535,7 +518,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -571,7 +553,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -595,7 +576,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -631,7 +611,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -655,7 +634,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -693,8 +671,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_broadcast_table;
-DROP TABLE IF EXISTS t_single_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -720,8 +696,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -759,7 +733,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_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -785,7 +758,6 @@ CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, 
country_id INT NOT NULL, m
 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -821,7 +793,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -845,7 +816,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -881,7 +851,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -905,7 +874,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -941,7 +909,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -965,7 +932,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1001,7 +967,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1025,7 +990,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1061,7 +1025,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1085,7 +1048,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1121,7 +1083,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1145,7 +1106,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1181,7 +1141,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1205,7 +1164,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
@@ -1241,7 +1199,6 @@ DROP TABLE IF EXISTS t_order_9;
 DROP TABLE IF EXISTS t_order_item_9;
 DROP TABLE IF EXISTS t_product_category;
 DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_broadcast_table;
 
 CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -1265,7 +1222,6 @@ CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id 
INT NOT NULL, status V
 CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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_0 ON t_order_0 (order_id);
 CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
 CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/dataset.xml
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/dataset.xml
index 18e0a2cfc90..b2d51db9763 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/dataset.xml
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/dataset.xml
@@ -75,15 +75,6 @@
         <column name="continent_name" type="varchar" />
         <column name="creation_date" type="datetime" />
     </metadata>
-    <metadata 
data-nodes="write_dataset.t_broadcast_table,read_dataset.t_broadcast_table">
-        <column name="id" type="numeric" />
-        <column name="status" type="varchar" />
-    </metadata>
-    <metadata data-nodes="read_dataset.t_single_table">
-        <column name="single_id" type="numeric" />
-        <column name="id" type="numeric" />
-        <column name="status" type="varchar" />
-    </metadata>
     <row data-node="write_dataset.t_order" values="1000, 10, init, 1, test, 
2017-08-08" />
     <row data-node="write_dataset.t_order" values="1001, 10, init, 2, test, 
2017-08-08" />
     <row data-node="write_dataset.t_order" values="1002, 10, init, 3, test, 
2017-08-08" />
@@ -480,11 +471,6 @@
     <row data-node="write_dataset.t_product_category" values="14, car, 13, 2, 
2017-08-08" />
     <row data-node="write_dataset.t_country" values="1, usa, north america, 
2017-08-08" />
     <row data-node="write_dataset.t_country" values="86, china, asia, 
2017-08-08" />
-    <row data-node="write_dataset.t_broadcast_table" values="1, init" />
-    <row data-node="read_dataset.t_single_table" values="1, 1000, init_read" />
-    <row data-node="read_dataset.t_single_table" values="2, 1101, init_read" />
-    <row data-node="read_dataset.t_single_table" values="3, 1202, init_read" />
-    <row data-node="read_dataset.t_single_table" values="4, 1303, init_read" />
     <row data-node="read_dataset.t_order" values="1000, 10, init_read, 1, 
test, 2017-08-08" />
     <row data-node="read_dataset.t_order" values="1001, 10, init_read, 2, 
test, 2017-08-08" />
     <row data-node="read_dataset.t_order" values="1002, 10, init_read, 3, 
test, 2017-08-08" />
@@ -881,5 +867,4 @@
     <row data-node="read_dataset.t_product_category" values="14, car, 13, 2, 
2017-08-08" />
     <row data-node="read_dataset.t_country" values="1, usa, north america, 
2017-08-08" />
     <row data-node="read_dataset.t_country" values="86, china, asia, 
2017-08-08" />
-    <row data-node="read_dataset.t_broadcast_table" values="1, init_read" />
 </dataset>
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
index 5d2fe087eee..bc710dac558 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
@@ -23,9 +23,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 INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -35,7 +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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
index 844d5eb282b..a06578290d6 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
@@ -29,9 +29,6 @@ CREATE TABLE write_dataset.t_product (product_id INT PRIMARY 
KEY, product_name V
 CREATE TABLE write_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 write_dataset.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE write_dataset.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-CREATE TABLE write_dataset.t_single_table (single_id INT NOT NULL 
AUTO_INCREMENT, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY 
(single_id));
-CREATE TABLE write_dataset.t_broadcast_table (id INT NOT NULL, status 
VARCHAR(45) NULL, PRIMARY KEY (id));
 
 CREATE INDEX order_index_t_order ON write_dataset.t_order (order_id);
 
@@ -47,8 +44,5 @@ CREATE TABLE read_dataset.t_product (product_id INT PRIMARY 
KEY, product_name VA
 CREATE TABLE read_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 read_dataset.t_product_category( category_id INT PRIMARY KEY, 
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE read_dataset.t_country (country_id INT PRIMARY KEY, country_name 
VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
--- TODO replace these tables with standard tables
-CREATE TABLE read_dataset.t_single_table (single_id INT NOT NULL 
AUTO_INCREMENT, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY 
(single_id));
-CREATE TABLE read_dataset.t_broadcast_table (id INT NOT NULL, status 
VARCHAR(45) NULL, PRIMARY KEY (id));
 
 CREATE INDEX order_index_t_order ON read_dataset.t_order (order_id);
diff --git 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
index 49e1be54cc8..34c1f4f9765 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/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 INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -42,9 +39,6 @@ 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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);
 
@@ -64,9 +58,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 INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -76,8 +67,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
index 49e1be54cc8..34c1f4f9765 100644
--- 
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
+++ 
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/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 INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -42,9 +39,6 @@ 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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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);
 
@@ -64,9 +58,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 INT PRIMARY KEY, user_id INT NOT NULL, status 
VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, 
creation_date DATE NOT NULL);
 CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, 
user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, 
creation_date DATE NOT NULL);
@@ -76,8 +67,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 INT NOT NULL, creation_date 
DATE NOT NULL);
 CREATE TABLE t_country (country_id INT 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);

(shardingsphere) branch master updated: Remove dbtbl_with_readwrite_splitting non-standard table (#30368)

Reply via email to