You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2022/12/02 11:01:06 UTC
[shardingsphere] branch master updated: Remove shardingRule in scenario readwrite_splitting and fix ci (#22530)
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 e797b32728c Remove shardingRule in scenario readwrite_splitting and fix ci (#22530)
e797b32728c is described below
commit e797b32728c269dd69082bc9dac39b0f0468dde1
Author: ICannerxy <40...@users.noreply.github.com>
AuthorDate: Fri Dec 2 19:00:59 2022 +0800
Remove shardingRule in scenario readwrite_splitting and fix ci (#22530)
* Add t_product_category,t_country standard table in readwrite_splitting scenario
* Fix ci
* Remove shardingRule in scenario readwrite_splitting and fix ci
* fix ci
* Fix ci
* Fix ci
---
.../readwrite_splitting/create_broadcast_index.xml | 24 ---------------------
.../cases/ddl/ddl-integration-test-cases.xml | 2 +-
.../cases/dml/dml-integration-test-cases.xml | 4 ++--
.../cases/dql/dql-integration-test-cases.xml | 8 +++----
.../count_single_table_rule.xml | 25 ----------------------
.../readwrite_splitting/show_broadcast_rules.xml | 24 ---------------------
.../show_sharding_binging_table_rules.xml | 24 ---------------------
.../readwrite_splitting/show_single_table.xml | 24 ---------------------
.../readwrite_splitting/show_single_tables.xml | 24 ---------------------
.../cases/rql/rql-integration-test-cases.xml | 10 ++++-----
.../readwrite_splitting/data/actual/dataset.xml | 24 ---------------------
.../data/actual/init-sql/h2/01-actual-init.sql | 4 ----
.../data/actual/init-sql/mysql/01-actual-init.sql | 6 ------
.../actual/init-sql/opengauss/01-actual-init.sql | 12 -----------
.../data/actual/init-sql/oracle/01-actual-init.sql | 6 ------
.../actual/init-sql/postgresql/01-actual-init.sql | 12 -----------
.../actual/init-sql/sqlserver/01-actual-init.sql | 6 ------
.../readwrite_splitting/data/expected/dataset.xml | 15 -------------
.../data/expected/init-sql/h2/01-expected-init.sql | 4 ----
.../expected/init-sql/mysql/01-expected-init.sql | 4 ----
.../init-sql/opengauss/01-expected-init.sql | 8 -------
.../expected/init-sql/oracle/01-expected-init.sql | 4 ----
.../init-sql/postgresql/01-expected-init.sql | 8 -------
.../init-sql/sqlserver/01-expected-init.sql | 4 ----
.../conf/mysql/config-readwrite-splitting.yaml | 5 -----
.../conf/opengauss/config-readwrite-splitting.yaml | 5 -----
.../postgresql/config-readwrite-splitting.yaml | 5 -----
.../env/scenario/readwrite_splitting/rules.yaml | 5 -----
28 files changed, 12 insertions(+), 294 deletions(-)
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ddl/dataset/readwrite_splitting/create_broadcast_index.xml b/test/integration-test/test-suite/src/test/resources/cases/ddl/dataset/readwrite_splitting/create_broadcast_index.xml
deleted file mode 100644
index 41d149a5c37..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/ddl/dataset/readwrite_splitting/create_broadcast_index.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata table-name="t_broadcast_table_for_ddl" data-nodes="write_ds.t_broadcast_table_for_ddl,read_${0..1}.t_broadcast_table_for_ddl">
- <column name="id" type="integer" />
- <column name="description" type="varchar" />
- <index name="t_broadcast_table_for_ddl_index_t_broadcast_table_for_ddl" column="id" unique="false" />
- </metadata>
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
index 75636f35402..33a26073307 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
@@ -95,7 +95,7 @@
</assertion>
</test-case>
- <test-case sql="CREATE INDEX t_broadcast_table_for_ddl_index ON t_broadcast_table_for_ddl (id)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="CREATE INDEX t_broadcast_table_for_ddl_index ON t_broadcast_table_for_ddl (id)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion expected-data-file="create_broadcast_index.xml">
<initial-sql sql="CREATE TABLE t_broadcast_table_for_ddl(id int, description varchar(10))" affected-table="t_broadcast_table_for_ddl" />
</assertion>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
index 6bd3d6e9147..7424caeb96b 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
@@ -112,7 +112,7 @@
<!--<!–<assertion parameters="1:int, 1:int, 2:int, 2:int" expected-data-file="batch_insert_without_generate_key_column.xml" />–>-->
<!--</test-case>-->
- <test-case sql="INSERT INTO t_broadcast_table(id, status) values (?, 'insert'),(?, 'insert')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="INSERT INTO t_broadcast_table(id, status) values (?, 'insert'),(?, 'insert')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="2:int, 3:int" expected-data-file="batch_insert_into_broadcast_table.xml" />
</test-case>
@@ -158,7 +158,7 @@
</test-case>
<!-- TODO FIXED ME PostgreSQL return 0 -->
- <test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion expected-data-file="update_broadcast_table.xml" />
</test-case>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
index cc8a1868dcd..3c6f43b6495 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
@@ -88,7 +88,7 @@
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status = c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND o.status = ? ORDER BY i.item_id" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status = c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND o.status = ? ORDER BY i.item_id" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="10:int, 11:int, 1001:int, 1100:int, init:String" expected-data-source-name="read_dataset" />
<assertion parameters="10:int, 11:int, 1009:int, 1108:int, none:String" expected-data-source-name="read_dataset" />
</test-case>
@@ -245,7 +245,7 @@
<assertion parameters="1000:int, 1100:int, 11:int" expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status = c.status WHERE (o.order_id = ? OR o.order_id = ?) AND o.user_id = ? AND o.status = ?" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id JOIN t_broadcast_table c ON o.status = c.status WHERE (o.order_id = ? OR o.order_id = ?) AND o.user_id = ? AND o.status = ?" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="1000:int, 1100:int, 11:int, init:String" expected-data-source-name="read_dataset" />
</test-case>
@@ -488,7 +488,7 @@
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM t_broadcast_table" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <test-case sql="SELECT * FROM t_broadcast_table" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion expected-data-source-name="read_dataset" />
</test-case>
<test-case sql="SELECT * FROM t_user WHERE user_id <= 15 ORDER BY user_id" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
@@ -514,7 +514,7 @@
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM t_single_table" db-types="MySQL,Oracle,SQLServer" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="SELECT * FROM t_single_table" db-types="MySQL,Oracle,SQLServer" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-source-name="read_dataset" />
</test-case>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/count_single_table_rule.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/count_single_table_rule.xml
deleted file mode 100644
index a5f4fc22e75..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/count_single_table_rule.xml
+++ /dev/null
@@ -1,25 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata>
- <column name="rule_name" />
- <column name="database" />
- <column name="count" />
- </metadata>
- <row values="single_table| readwrite_splitting| 1" />
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_broadcast_rules.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_broadcast_rules.xml
deleted file mode 100644
index 36861181d00..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_broadcast_rules.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata>
- <column name="broadcast_table" />
- </metadata>
- <row values="t_broadcast_table" />
- <row values="t_broadcast_table_for_ddl" />
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_sharding_binging_table_rules.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_sharding_binging_table_rules.xml
deleted file mode 100644
index 70d1e8c6054..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_sharding_binging_table_rules.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata>
- <column name="name" />
- <column name="sharding_table_reference" />
- </metadata>
- <row values="ref_0| t_order,t_order_item,t_order_details" />
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_table.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_table.xml
deleted file mode 100644
index 2053c42b49c..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_table.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
- </metadata>
- <row values="t_single_table| write-read-ds" />
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_tables.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_tables.xml
deleted file mode 100644
index 2053c42b49c..00000000000
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/dataset/readwrite_splitting/show_single_tables.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<!--
- ~ Licensed to the Apache Software Foundation (ASF) under one or more
- ~ contributor license agreements. See the NOTICE file distributed with
- ~ this work for additional information regarding copyright ownership.
- ~ The ASF licenses this file to You under the Apache License, Version 2.0
- ~ (the "License"); you may not use this file except in compliance with
- ~ the License. You may obtain a copy of the License at
- ~
- ~ http://www.apache.org/licenses/LICENSE-2.0
- ~
- ~ Unless required by applicable law or agreed to in writing, software
- ~ distributed under the License is distributed on an "AS IS" BASIS,
- ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- ~ See the License for the specific language governing permissions and
- ~ limitations under the License.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="resource_name" />
- </metadata>
- <row values="t_single_table| write-read-ds" />
-</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/rql/rql-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/rql/rql-integration-test-cases.xml
index b78730e92fc..760d453b189 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/rql/rql-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/rql/rql-integration-test-cases.xml
@@ -81,11 +81,11 @@
<assertion expected-data-file="show_sharding_table_nodes.xml" />
</test-case>
- <test-case sql="SHOW SHARDING TABLE REFERENCE RULES" scenario-types="db,tbl,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt">
+ <test-case sql="SHOW SHARDING TABLE REFERENCE RULES" scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt">
<assertion expected-data-file="show_sharding_binging_table_rules.xml" />
</test-case>
- <test-case sql="SHOW BROADCAST TABLE RULES" scenario-types="db,tbl,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt">
+ <test-case sql="SHOW BROADCAST TABLE RULES" scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt">
<assertion expected-data-file="show_broadcast_rules.xml" />
</test-case>
@@ -93,15 +93,15 @@
<assertion expected-data-file="show_single_table_rules.xml" />
</test-case>
- <test-case sql="SHOW SINGLE TABLE t_single_table" scenario-types="db,tbl,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="SHOW SINGLE TABLE t_single_table" scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="show_single_table.xml" />
</test-case>
- <test-case sql="SHOW SINGLE TABLES" scenario-types="db,tbl,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="SHOW SINGLE TABLES" scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="show_single_tables.xml" />
</test-case>
- <test-case sql="COUNT SINGLE_TABLE RULE" scenario-types="db,tbl,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="COUNT SINGLE_TABLE RULE" scenario-types="db,tbl,encrypt,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="count_single_table_rule.xml" />
</test-case>
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/dataset.xml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/dataset.xml
index 3831df9fd46..3a0bbc40f17 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/dataset.xml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/dataset.xml
@@ -32,15 +32,6 @@
<column name="quantity" type="numeric" />
<column name="creation_date" type="datetime" />
</metadata>
- <metadata data-nodes="write_ds.t_broadcast_table,read_${0..1}.t_broadcast_table">
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
- <metadata data-nodes="write_ds.t_single_table,read_${0..1}.t_single_table">
- <column name="single_id" type="numeric" />
- <column name="id" type="numeric" />
- <column name="status" type="varchar" />
- </metadata>
<row data-node="write_ds.t_order" values="1000, 10, init, 1, test, 2017-08-08" />
<row data-node="write_ds.t_order" values="1001, 10, init, 2, test, 2017-08-08" />
<row data-node="write_ds.t_order" values="1100, 11, init, 3, test, 2017-08-08" />
@@ -161,11 +152,6 @@
<row data-node="write_ds.t_order_item" values="290002, 2900, 29, 8, 1, 2017-08-08" />
<row data-node="write_ds.t_order_item" values="290101, 2901, 29, 9, 1, 2017-08-08" />
<row data-node="write_ds.t_order_item" values="290102, 2901, 29, 10, 1, 2017-08-08" />
- <row data-node="write_ds.t_single_table" values="1, 1000, init" />
- <row data-node="write_ds.t_single_table" values="2, 1100, init" />
- <row data-node="write_ds.t_single_table" values="3, 1200, init" />
- <row data-node="write_ds.t_single_table" values="4, 1300, init" />
- <row data-node="write_ds.t_broadcast_table" values="1, init" />
<row data-node="read_0.t_order" values="1000, 10, init_read, 1, test, 2017-08-08" />
<row data-node="read_0.t_order" values="1001, 10, init_read, 2, test, 2017-08-08" />
<row data-node="read_0.t_order" values="1100, 11, init_read, 3, test, 2017-08-08" />
@@ -286,11 +272,6 @@
<row data-node="read_0.t_order_item" values="290002, 2900, 29, 8, 1, 2017-08-08" />
<row data-node="read_0.t_order_item" values="290101, 2901, 29, 9, 1, 2017-08-08" />
<row data-node="read_0.t_order_item" values="290102, 2901, 29, 10, 1, 2017-08-08" />
- <row data-node="read_0.t_single_table" values="1, 1000, init_read" />
- <row data-node="read_0.t_single_table" values="2, 1100, init_read" />
- <row data-node="read_0.t_single_table" values="3, 1200, init_read" />
- <row data-node="read_0.t_single_table" values="4, 1300, init_read" />
- <row data-node="read_0.t_broadcast_table" values="1, init_read" />
<row data-node="read_1.t_order" values="1000, 10, init_read, 1, test, 2017-08-08" />
<row data-node="read_1.t_order" values="1001, 10, init_read, 2, test, 2017-08-08" />
<row data-node="read_1.t_order" values="1100, 11, init_read, 3, test, 2017-08-08" />
@@ -411,9 +392,4 @@
<row data-node="read_1.t_order_item" values="290002, 2900, 29, 8, 1, 2017-08-08" />
<row data-node="read_1.t_order_item" values="290101, 2901, 29, 9, 1, 2017-08-08" />
<row data-node="read_1.t_order_item" values="290102, 2901, 29, 10, 1, 2017-08-08" />
- <row data-node="read_1.t_single_table" values="1, 1000, init_read" />
- <row data-node="read_1.t_single_table" values="2, 1100, init_read" />
- <row data-node="read_1.t_single_table" values="3, 1200, init_read" />
- <row data-node="read_1.t_single_table" values="4, 1300, init_read" />
- <row data-node="read_1.t_broadcast_table" values="1, init_read" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
index a81a39f17e9..8b6c213811c 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
@@ -17,12 +17,8 @@
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_broadcast_table;
-DROP TABLE IF EXISTS t_single_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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
index 188880ae04f..7c02164eede 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
@@ -28,18 +28,12 @@ CREATE DATABASE read_1;
CREATE TABLE write_ds.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 write_ds.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);
-CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.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 read_0.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);
-CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.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 read_1.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);
-CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
index f4609c70f26..119ad3c56fd 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/opengauss/01-actual-init.sql
@@ -27,37 +27,25 @@ GRANT ALL PRIVILEGES ON DATABASE read_1 TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c read_0
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c read_1
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
index 73140bd1a16..8a4fe78756b 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
@@ -25,18 +25,12 @@ CREATE SCHEMA read_1;
CREATE TABLE write_ds.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 write_ds.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);
-CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.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 read_0.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);
-CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.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 read_1.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);
-CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
index f4609c70f26..119ad3c56fd 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -27,37 +27,25 @@ GRANT ALL PRIVILEGES ON DATABASE read_1 TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c read_0
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
\c read_1
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
index 43de488c541..27b44d56f2a 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -25,18 +25,12 @@ CREATE DATABASE read_1;
CREATE TABLE write_ds.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 write_ds.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);
-CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.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 read_0.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);
-CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.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 read_1.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);
-CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/dataset.xml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/dataset.xml
index 0677623b8e2..7345f20208d 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/dataset.xml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/dataset.xml
@@ -32,15 +32,6 @@
<column name="quantity" type="numeric" />
<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="1100, 11, init, 3, test, 2017-08-08" />
@@ -161,11 +152,6 @@
<row data-node="write_dataset.t_order_item" values="290002, 2900, 29, 8, 1, 2017-08-08" />
<row data-node="write_dataset.t_order_item" values="290101, 2901, 29, 9, 1, 2017-08-08" />
<row data-node="write_dataset.t_order_item" values="290102, 2901, 29, 10, 1, 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, 1100, init_read" />
- <row data-node="read_dataset.t_single_table" values="3, 1200, init_read" />
- <row data-node="read_dataset.t_single_table" values="4, 1300, 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="1100, 11, init_read, 3, test, 2017-08-08" />
@@ -286,5 +272,4 @@
<row data-node="read_dataset.t_order_item" values="290002, 2900, 29, 8, 1, 2017-08-08" />
<row data-node="read_dataset.t_order_item" values="290101, 2901, 29, 9, 1, 2017-08-08" />
<row data-node="read_dataset.t_order_item" values="290102, 2901, 29, 10, 1, 2017-08-08" />
- <row data-node="read_dataset.t_broadcast_table" values="1, init_read" />
</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
index e2796d7848a..8b6c213811c 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
@@ -17,12 +17,8 @@
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
index 09f9a4acb36..c6abd739362 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
@@ -24,8 +24,6 @@ CREATE DATABASE write_dataset;
CREATE TABLE write_dataset.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 write_dataset.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);
-CREATE TABLE write_dataset.t_single_table (single_id INT NOT NULL, 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);
@@ -35,7 +33,5 @@ CREATE DATABASE read_dataset;
CREATE TABLE read_dataset.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 read_dataset.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);
-CREATE TABLE read_dataset.t_single_table (single_id INT NOT NULL, 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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
index 81899564e52..0711965cf69 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/opengauss/01-expected-init.sql
@@ -24,13 +24,9 @@ GRANT ALL PRIVILEGES ON DATABASE write_dataset TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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);
@@ -44,12 +40,8 @@ GRANT ALL PRIVILEGES ON DATABASE read_dataset TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
index 8767254374c..fe5b222f9bd 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
@@ -20,8 +20,6 @@ CREATE SCHEMA write_dataset;
CREATE TABLE write_dataset.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 write_dataset.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);
-CREATE TABLE write_dataset.t_single_table (single_id INT NOT NULL, 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);
@@ -31,7 +29,5 @@ CREATE SCHEMA read_dataset;
CREATE TABLE read_dataset.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 read_dataset.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);
-CREATE TABLE read_dataset.t_single_table (single_id INT NOT NULL, 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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
index 81899564e52..0711965cf69 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -24,13 +24,9 @@ GRANT ALL PRIVILEGES ON DATABASE write_dataset TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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);
@@ -44,12 +40,8 @@ GRANT ALL PRIVILEGES ON DATABASE read_dataset TO test_user;
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
-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);
-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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
index 1f57f2763f9..d828fb07839 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -20,8 +20,6 @@ CREATE DATABASE write_dataset;
CREATE TABLE write_dataset.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 write_dataset.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);
-CREATE TABLE write_dataset.t_single_table (single_id INT NOT NULL, 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);
@@ -31,7 +29,5 @@ CREATE DATABASE read_dataset;
CREATE TABLE read_dataset.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 read_dataset.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);
-CREATE TABLE read_dataset.t_single_table (single_id INT NOT NULL, 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/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
index 5f513d85316..c83a38fecb6 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/mysql/config-readwrite-splitting.yaml
@@ -67,11 +67,6 @@ rules:
none:
databaseStrategy:
none:
- bindingTables:
- - ref_0:t_order,t_order_item,t_order_details
- broadcastTables:
- - t_broadcast_table
- - t_broadcast_table_for_ddl
- !READWRITE_SPLITTING
dataSources:
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/opengauss/config-readwrite-splitting.yaml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/opengauss/config-readwrite-splitting.yaml
index 969a3d160e4..5a81bb83a11 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/opengauss/config-readwrite-splitting.yaml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/opengauss/config-readwrite-splitting.yaml
@@ -67,11 +67,6 @@ rules:
none:
databaseStrategy:
none:
- bindingTables:
- - ref_0:t_order,t_order_item,t_order_details
- broadcastTables:
- - t_broadcast_table
- - t_broadcast_table_for_ddl
- !READWRITE_SPLITTING
dataSources:
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
index 66b20622618..140c7cb21e4 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/proxy/conf/postgresql/config-readwrite-splitting.yaml
@@ -67,11 +67,6 @@ rules:
none:
databaseStrategy:
none:
- bindingTables:
- - ref_0:t_order,t_order_item,t_order_details
- broadcastTables:
- - t_broadcast_table
- - t_broadcast_table_for_ddl
- !READWRITE_SPLITTING
dataSources:
diff --git a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/rules.yaml b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/rules.yaml
index 10460372051..507ea97bc62 100644
--- a/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/rules.yaml
+++ b/test/integration-test/test-suite/src/test/resources/env/scenario/readwrite_splitting/rules.yaml
@@ -36,11 +36,6 @@ rules:
none:
databaseStrategy:
none:
- bindingTables:
- - ref_0:t_order,t_order_item,t_order_details
- broadcastTables:
- - t_broadcast_table
- - t_broadcast_table_for_ddl
- !READWRITE_SPLITTING
dataSources: