You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2021/01/19 10:10:00 UTC
[shardingsphere] branch master updated: add a test of left-join
(#9088)
This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 5218c12 add a test of left-join (#9088)
5218c12 is described below
commit 5218c127a4568f997e3656f107ab399cfa3c8a04
Author: Jieker <ji...@163.com>
AuthorDate: Tue Jan 19 18:09:27 2021 +0800
add a test of left-join (#9088)
* add left_join test
* prefect format
---
.../cases/dql/dataset/db/select_for_left_join.xml | 109 ++++++++++
.../select_for_left_join.xml | 229 +++++++++++++++++++++
.../dataset/replica_query/select_for_left_join.xml | 109 ++++++++++
.../cases/dql/dataset/tbl/select_for_left_join.xml | 69 +++++++
.../cases/dql/dql-integration-test-cases.xml | 4 +
5 files changed, 520 insertions(+)
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/db/select_for_left_join.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/db/select_for_left_join.xml
new file mode 100644
index 0000000..4d0d29d
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/db/select_for_left_join.xml
@@ -0,0 +1,109 @@
+<!--
+ ~ 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="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="item_id" />
+ <column name="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="creation_date" />
+ </metadata>
+ <row values="1000, 10, init, 100001, 1000, 10, init, 2017-08-08" />
+ <row values="1000, 10, init, 100002, 1000, 10, init, 2017-08-08" />
+ <row values="1001, 10, init, 100101, 1001, 10, init, 2017-08-08" />
+ <row values="1001, 10, init, 100102, 1001, 10, init, 2017-08-08" />
+ <row values="2000, 20, init, 200001, 2000, 20, init, 2017-08-08" />
+ <row values="2000, 20, init, 200002, 2000, 20, init, 2017-08-08" />
+ <row values="2001, 20, init, 200101, 2001, 20, init, 2017-08-08" />
+ <row values="2001, 20, init, 200102, 2001, 20, init, 2017-08-08" />
+ <row values="1100, 11, init, 110001, 1100, 11, init, 2017-08-08" />
+ <row values="1100, 11, init, 110002, 1100, 11, init, 2017-08-08" />
+ <row values="1101, 11, init, 110101, 1101, 11, init, 2017-08-08" />
+ <row values="1101, 11, init, 110102, 1101, 11, init, 2017-08-08" />
+ <row values="2100, 21, init, 210001, 2100, 21, init, 2017-08-08" />
+ <row values="2100, 21, init, 210002, 2100, 21, init, 2017-08-08" />
+ <row values="2101, 21, init, 210101, 2101, 21, init, 2017-08-08" />
+ <row values="2101, 21, init, 210102, 2101, 21, init, 2017-08-08" />
+ <row values="1200, 12, init, 120001, 1200, 12, init, 2017-08-08" />
+ <row values="1200, 12, init, 120002, 1200, 12, init, 2017-08-08" />
+ <row values="1201, 12, init, 120101, 1201, 12, init, 2017-08-08" />
+ <row values="1201, 12, init, 120102, 1201, 12, init, 2017-08-08" />
+ <row values="2200, 22, init, 220001, 2200, 22, init, 2017-08-08" />
+ <row values="2200, 22, init, 220002, 2200, 22, init, 2017-08-08" />
+ <row values="2201, 22, init, 220101, 2201, 22, init, 2017-08-08" />
+ <row values="2201, 22, init, 220102, 2201, 22, init, 2017-08-08" />
+ <row values="1300, 13, init, 130001, 1300, 13, init, 2017-08-08" />
+ <row values="1300, 13, init, 130002, 1300, 13, init, 2017-08-08" />
+ <row values="1301, 13, init, 130101, 1301, 13, init, 2017-08-08" />
+ <row values="1301, 13, init, 130102, 1301, 13, init, 2017-08-08" />
+ <row values="2300, 23, init, 230001, 2300, 23, init, 2017-08-08" />
+ <row values="2300, 23, init, 230002, 2300, 23, init, 2017-08-08" />
+ <row values="2301, 23, init, 230101, 2301, 23, init, 2017-08-08" />
+ <row values="2301, 23, init, 230102, 2301, 23, init, 2017-08-08" />
+ <row values="1400, 14, init, 140001, 1400, 14, init, 2017-08-08" />
+ <row values="1400, 14, init, 140002, 1400, 14, init, 2017-08-08" />
+ <row values="1401, 14, init, 140101, 1401, 14, init, 2017-08-08" />
+ <row values="1401, 14, init, 140102, 1401, 14, init, 2017-08-08" />
+ <row values="2400, 24, init, 240001, 2400, 24, init, 2017-08-08" />
+ <row values="2400, 24, init, 240002, 2400, 24, init, 2017-08-08" />
+ <row values="2401, 24, init, 240101, 2401, 24, init, 2017-08-08" />
+ <row values="2401, 24, init, 240102, 2401, 24, init, 2017-08-08" />
+ <row values="1500, 15, init, 150001, 1500, 15, init, 2017-08-08" />
+ <row values="1500, 15, init, 150002, 1500, 15, init, 2017-08-08" />
+ <row values="1501, 15, init, 150101, 1501, 15, init, 2017-08-08" />
+ <row values="1501, 15, init, 150102, 1501, 15, init, 2017-08-08" />
+ <row values="2500, 25, init, 250001, 2500, 25, init, 2017-08-08" />
+ <row values="2500, 25, init, 250002, 2500, 25, init, 2017-08-08" />
+ <row values="2501, 25, init, 250101, 2501, 25, init, 2017-08-08" />
+ <row values="2501, 25, init, 250102, 2501, 25, init, 2017-08-08" />
+ <row values="1600, 16, init, 160001, 1600, 16, init, 2017-08-08" />
+ <row values="1600, 16, init, 160002, 1600, 16, init, 2017-08-08" />
+ <row values="1601, 16, init, 160101, 1601, 16, init, 2017-08-08" />
+ <row values="1601, 16, init, 160102, 1601, 16, init, 2017-08-08" />
+ <row values="2600, 26, init, 260001, 2600, 26, init, 2017-08-08" />
+ <row values="2600, 26, init, 260002, 2600, 26, init, 2017-08-08" />
+ <row values="2601, 26, init, 260101, 2601, 26, init, 2017-08-08" />
+ <row values="2601, 26, init, 260102, 2601, 26, init, 2017-08-08" />
+ <row values="1700, 17, init, 170001, 1700, 17, init, 2017-08-08" />
+ <row values="1700, 17, init, 170002, 1700, 17, init, 2017-08-08" />
+ <row values="1701, 17, init, 170101, 1701, 17, init, 2017-08-08" />
+ <row values="1701, 17, init, 170102, 1701, 17, init, 2017-08-08" />
+ <row values="2700, 27, init, 270001, 2700, 27, init, 2017-08-08" />
+ <row values="2700, 27, init, 270002, 2700, 27, init, 2017-08-08" />
+ <row values="2701, 27, init, 270101, 2701, 27, init, 2017-08-08" />
+ <row values="2701, 27, init, 270102, 2701, 27, init, 2017-08-08" />
+ <row values="1800, 18, init, 180001, 1800, 18, init, 2017-08-08" />
+ <row values="1800, 18, init, 180002, 1800, 18, init, 2017-08-08" />
+ <row values="1801, 18, init, 180101, 1801, 18, init, 2017-08-08" />
+ <row values="1801, 18, init, 180102, 1801, 18, init, 2017-08-08" />
+ <row values="2800, 28, init, 280001, 2800, 28, init, 2017-08-08" />
+ <row values="2800, 28, init, 280002, 2800, 28, init, 2017-08-08" />
+ <row values="2801, 28, init, 280101, 2801, 28, init, 2017-08-08" />
+ <row values="2801, 28, init, 280102, 2801, 28, init, 2017-08-08" />
+ <row values="1900, 19, init, 190001, 1900, 19, init, 2017-08-08" />
+ <row values="1900, 19, init, 190002, 1900, 19, init, 2017-08-08" />
+ <row values="1901, 19, init, 190101, 1901, 19, init, 2017-08-08" />
+ <row values="1901, 19, init, 190102, 1901, 19, init, 2017-08-08" />
+ <row values="2900, 29, init, 290001, 2900, 29, init, 2017-08-08" />
+ <row values="2900, 29, init, 290002, 2900, 29, init, 2017-08-08" />
+ <row values="2901, 29, init, 290101, 2901, 29, init, 2017-08-08" />
+ <row values="2901, 29, init, 290102, 2901, 29, init, 2017-08-08" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/dbtbl_with_replica_query/select_for_left_join.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/dbtbl_with_replica_query/select_for_left_join.xml
new file mode 100644
index 0000000..33e9cd0
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/dbtbl_with_replica_query/select_for_left_join.xml
@@ -0,0 +1,229 @@
+<!--
+ ~ 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="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="item_id" />
+ <column name="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="creation_date" />
+ </metadata>
+ <row values="1000, 10, init_replica, 100000, 1000, 10, init_replica, 2017-08-08" />
+ <row values="1000, 10, init_replica, 100001, 1000, 10, init_replica, 2017-08-08" />
+ <row values="1001, 10, init_replica, 100100, 1001, 10, init_replica, 2017-08-08" />
+ <row values="1001, 10, init_replica, 100101, 1001, 10, init_replica, 2017-08-08" />
+ <row values="1002, 10, init_replica, 100200, 1002, 10, init_replica, 2017-08-08" />
+ <row values="1002, 10, init_replica, 100201, 1002, 10, init_replica, 2017-08-08" />
+ <row values="1003, 10, init_replica, 100300, 1003, 10, init_replica, 2017-08-08" />
+ <row values="1003, 10, init_replica, 100301, 1003, 10, init_replica, 2017-08-08" />
+ <row values="1004, 10, init_replica, 100400, 1004, 10, init_replica, 2017-08-08" />
+ <row values="1004, 10, init_replica, 100401, 1004, 10, init_replica, 2017-08-08" />
+ <row values="1005, 10, init_replica, 100500, 1005, 10, init_replica, 2017-08-08" />
+ <row values="1005, 10, init_replica, 100501, 1005, 10, init_replica, 2017-08-08" />
+ <row values="1006, 10, init_replica, 100600, 1006, 10, init_replica, 2017-08-08" />
+ <row values="1006, 10, init_replica, 100601, 1006, 10, init_replica, 2017-08-08" />
+ <row values="1007, 10, init_replica, 100700, 1007, 10, init_replica, 2017-08-08" />
+ <row values="1007, 10, init_replica, 100701, 1007, 10, init_replica, 2017-08-08" />
+ <row values="1008, 10, init_replica, 100800, 1008, 10, init_replica, 2017-08-08" />
+ <row values="1008, 10, init_replica, 100801, 1008, 10, init_replica, 2017-08-08" />
+ <row values="1009, 10, init_replica, 100900, 1009, 10, init_replica, 2017-08-08" />
+ <row values="1009, 10, init_replica, 100901, 1009, 10, init_replica, 2017-08-08" />
+ <row values="1100, 11, init_replica, 110000, 1100, 11, init_replica, 2017-08-08" />
+ <row values="1100, 11, init_replica, 110001, 1100, 11, init_replica, 2017-08-08" />
+ <row values="1101, 11, init_replica, 110100, 1101, 11, init_replica, 2017-08-08" />
+ <row values="1101, 11, init_replica, 110101, 1101, 11, init_replica, 2017-08-08" />
+ <row values="1102, 11, init_replica, 110200, 1102, 11, init_replica, 2017-08-08" />
+ <row values="1102, 11, init_replica, 110201, 1102, 11, init_replica, 2017-08-08" />
+ <row values="1103, 11, init_replica, 110300, 1103, 11, init_replica, 2017-08-08" />
+ <row values="1103, 11, init_replica, 110301, 1103, 11, init_replica, 2017-08-08" />
+ <row values="1104, 11, init_replica, 110400, 1104, 11, init_replica, 2017-08-08" />
+ <row values="1104, 11, init_replica, 110401, 1104, 11, init_replica, 2017-08-08" />
+ <row values="1105, 11, init_replica, 110500, 1105, 11, init_replica, 2017-08-08" />
+ <row values="1105, 11, init_replica, 110501, 1105, 11, init_replica, 2017-08-08" />
+ <row values="1106, 11, init_replica, 110600, 1106, 11, init_replica, 2017-08-08" />
+ <row values="1106, 11, init_replica, 110601, 1106, 11, init_replica, 2017-08-08" />
+ <row values="1107, 11, init_replica, 110700, 1107, 11, init_replica, 2017-08-08" />
+ <row values="1107, 11, init_replica, 110701, 1107, 11, init_replica, 2017-08-08" />
+ <row values="1108, 11, init_replica, 110800, 1108, 11, init_replica, 2017-08-08" />
+ <row values="1108, 11, init_replica, 110801, 1108, 11, init_replica, 2017-08-08" />
+ <row values="1109, 11, init_replica, 110900, 1109, 11, init_replica, 2017-08-08" />
+ <row values="1109, 11, init_replica, 110901, 1109, 11, init_replica, 2017-08-08" />
+ <row values="1200, 12, init_replica, 120000, 1200, 12, init_replica, 2017-08-08" />
+ <row values="1200, 12, init_replica, 120001, 1200, 12, init_replica, 2017-08-08" />
+ <row values="1201, 12, init_replica, 120100, 1201, 12, init_replica, 2017-08-08" />
+ <row values="1201, 12, init_replica, 120101, 1201, 12, init_replica, 2017-08-08" />
+ <row values="1202, 12, init_replica, 120200, 1202, 12, init_replica, 2017-08-08" />
+ <row values="1202, 12, init_replica, 120201, 1202, 12, init_replica, 2017-08-08" />
+ <row values="1203, 12, init_replica, 120300, 1203, 12, init_replica, 2017-08-08" />
+ <row values="1203, 12, init_replica, 120301, 1203, 12, init_replica, 2017-08-08" />
+ <row values="1204, 12, init_replica, 120400, 1204, 12, init_replica, 2017-08-08" />
+ <row values="1204, 12, init_replica, 120401, 1204, 12, init_replica, 2017-08-08" />
+ <row values="1205, 12, init_replica, 120500, 1205, 12, init_replica, 2017-08-08" />
+ <row values="1205, 12, init_replica, 120501, 1205, 12, init_replica, 2017-08-08" />
+ <row values="1206, 12, init_replica, 120600, 1206, 12, init_replica, 2017-08-08" />
+ <row values="1206, 12, init_replica, 120601, 1206, 12, init_replica, 2017-08-08" />
+ <row values="1207, 12, init_replica, 120700, 1207, 12, init_replica, 2017-08-08" />
+ <row values="1207, 12, init_replica, 120701, 1207, 12, init_replica, 2017-08-08" />
+ <row values="1208, 12, init_replica, 120800, 1208, 12, init_replica, 2017-08-08" />
+ <row values="1208, 12, init_replica, 120801, 1208, 12, init_replica, 2017-08-08" />
+ <row values="1209, 12, init_replica, 120900, 1209, 12, init_replica, 2017-08-08" />
+ <row values="1209, 12, init_replica, 120901, 1209, 12, init_replica, 2017-08-08" />
+ <row values="1300, 13, init_replica, 130000, 1300, 13, init_replica, 2017-08-08" />
+ <row values="1300, 13, init_replica, 130001, 1300, 13, init_replica, 2017-08-08" />
+ <row values="1301, 13, init_replica, 130100, 1301, 13, init_replica, 2017-08-08" />
+ <row values="1301, 13, init_replica, 130101, 1301, 13, init_replica, 2017-08-08" />
+ <row values="1302, 13, init_replica, 130200, 1302, 13, init_replica, 2017-08-08" />
+ <row values="1302, 13, init_replica, 130201, 1302, 13, init_replica, 2017-08-08" />
+ <row values="1303, 13, init_replica, 130300, 1303, 13, init_replica, 2017-08-08" />
+ <row values="1303, 13, init_replica, 130301, 1303, 13, init_replica, 2017-08-08" />
+ <row values="1304, 13, init_replica, 130400, 1304, 13, init_replica, 2017-08-08" />
+ <row values="1304, 13, init_replica, 130401, 1304, 13, init_replica, 2017-08-08" />
+ <row values="1305, 13, init_replica, 130500, 1305, 13, init_replica, 2017-08-08" />
+ <row values="1305, 13, init_replica, 130501, 1305, 13, init_replica, 2017-08-08" />
+ <row values="1306, 13, init_replica, 130600, 1306, 13, init_replica, 2017-08-08" />
+ <row values="1306, 13, init_replica, 130601, 1306, 13, init_replica, 2017-08-08" />
+ <row values="1307, 13, init_replica, 130700, 1307, 13, init_replica, 2017-08-08" />
+ <row values="1307, 13, init_replica, 130701, 1307, 13, init_replica, 2017-08-08" />
+ <row values="1308, 13, init_replica, 130800, 1308, 13, init_replica, 2017-08-08" />
+ <row values="1308, 13, init_replica, 130801, 1308, 13, init_replica, 2017-08-08" />
+ <row values="1309, 13, init_replica, 130900, 1309, 13, init_replica, 2017-08-08" />
+ <row values="1309, 13, init_replica, 130901, 1309, 13, init_replica, 2017-08-08" />
+ <row values="1400, 14, init_replica, 140000, 1400, 14, init_replica, 2017-08-08" />
+ <row values="1400, 14, init_replica, 140001, 1400, 14, init_replica, 2017-08-08" />
+ <row values="1401, 14, init_replica, 140100, 1401, 14, init_replica, 2017-08-08" />
+ <row values="1401, 14, init_replica, 140101, 1401, 14, init_replica, 2017-08-08" />
+ <row values="1402, 14, init_replica, 140200, 1402, 14, init_replica, 2017-08-08" />
+ <row values="1402, 14, init_replica, 140201, 1402, 14, init_replica, 2017-08-08" />
+ <row values="1403, 14, init_replica, 140300, 1403, 14, init_replica, 2017-08-08" />
+ <row values="1403, 14, init_replica, 140301, 1403, 14, init_replica, 2017-08-08" />
+ <row values="1404, 14, init_replica, 140400, 1404, 14, init_replica, 2017-08-08" />
+ <row values="1404, 14, init_replica, 140401, 1404, 14, init_replica, 2017-08-08" />
+ <row values="1405, 14, init_replica, 140500, 1405, 14, init_replica, 2017-08-08" />
+ <row values="1405, 14, init_replica, 140501, 1405, 14, init_replica, 2017-08-08" />
+ <row values="1406, 14, init_replica, 140600, 1406, 14, init_replica, 2017-08-08" />
+ <row values="1406, 14, init_replica, 140601, 1406, 14, init_replica, 2017-08-08" />
+ <row values="1407, 14, init_replica, 140700, 1407, 14, init_replica, 2017-08-08" />
+ <row values="1407, 14, init_replica, 140701, 1407, 14, init_replica, 2017-08-08" />
+ <row values="1408, 14, init_replica, 140800, 1408, 14, init_replica, 2017-08-08" />
+ <row values="1408, 14, init_replica, 140801, 1408, 14, init_replica, 2017-08-08" />
+ <row values="1409, 14, init_replica, 140900, 1409, 14, init_replica, 2017-08-08" />
+ <row values="1409, 14, init_replica, 140901, 1409, 14, init_replica, 2017-08-08" />
+ <row values="1500, 15, init_replica, 150000, 1500, 15, init_replica, 2017-08-08" />
+ <row values="1500, 15, init_replica, 150001, 1500, 15, init_replica, 2017-08-08" />
+ <row values="1501, 15, init_replica, 150100, 1501, 15, init_replica, 2017-08-08" />
+ <row values="1501, 15, init_replica, 150101, 1501, 15, init_replica, 2017-08-08" />
+ <row values="1502, 15, init_replica, 150200, 1502, 15, init_replica, 2017-08-08" />
+ <row values="1502, 15, init_replica, 150201, 1502, 15, init_replica, 2017-08-08" />
+ <row values="1503, 15, init_replica, 150300, 1503, 15, init_replica, 2017-08-08" />
+ <row values="1503, 15, init_replica, 150301, 1503, 15, init_replica, 2017-08-08" />
+ <row values="1504, 15, init_replica, 150400, 1504, 15, init_replica, 2017-08-08" />
+ <row values="1504, 15, init_replica, 150401, 1504, 15, init_replica, 2017-08-08" />
+ <row values="1505, 15, init_replica, 150500, 1505, 15, init_replica, 2017-08-08" />
+ <row values="1505, 15, init_replica, 150501, 1505, 15, init_replica, 2017-08-08" />
+ <row values="1506, 15, init_replica, 150600, 1506, 15, init_replica, 2017-08-08" />
+ <row values="1506, 15, init_replica, 150601, 1506, 15, init_replica, 2017-08-08" />
+ <row values="1507, 15, init_replica, 150700, 1507, 15, init_replica, 2017-08-08" />
+ <row values="1507, 15, init_replica, 150701, 1507, 15, init_replica, 2017-08-08" />
+ <row values="1508, 15, init_replica, 150800, 1508, 15, init_replica, 2017-08-08" />
+ <row values="1508, 15, init_replica, 150801, 1508, 15, init_replica, 2017-08-08" />
+ <row values="1509, 15, init_replica, 150900, 1509, 15, init_replica, 2017-08-08" />
+ <row values="1509, 15, init_replica, 150901, 1509, 15, init_replica, 2017-08-08" />
+ <row values="1600, 16, init_replica, 160000, 1600, 16, init_replica, 2017-08-08" />
+ <row values="1600, 16, init_replica, 160001, 1600, 16, init_replica, 2017-08-08" />
+ <row values="1601, 16, init_replica, 160100, 1601, 16, init_replica, 2017-08-08" />
+ <row values="1601, 16, init_replica, 160101, 1601, 16, init_replica, 2017-08-08" />
+ <row values="1602, 16, init_replica, 160200, 1602, 16, init_replica, 2017-08-08" />
+ <row values="1602, 16, init_replica, 160201, 1602, 16, init_replica, 2017-08-08" />
+ <row values="1603, 16, init_replica, 160300, 1603, 16, init_replica, 2017-08-08" />
+ <row values="1603, 16, init_replica, 160301, 1603, 16, init_replica, 2017-08-08" />
+ <row values="1604, 16, init_replica, 160400, 1604, 16, init_replica, 2017-08-08" />
+ <row values="1604, 16, init_replica, 160401, 1604, 16, init_replica, 2017-08-08" />
+ <row values="1605, 16, init_replica, 160500, 1605, 16, init_replica, 2017-08-08" />
+ <row values="1605, 16, init_replica, 160501, 1605, 16, init_replica, 2017-08-08" />
+ <row values="1606, 16, init_replica, 160600, 1606, 16, init_replica, 2017-08-08" />
+ <row values="1606, 16, init_replica, 160601, 1606, 16, init_replica, 2017-08-08" />
+ <row values="1607, 16, init_replica, 160700, 1607, 16, init_replica, 2017-08-08" />
+ <row values="1607, 16, init_replica, 160701, 1607, 16, init_replica, 2017-08-08" />
+ <row values="1608, 16, init_replica, 160800, 1608, 16, init_replica, 2017-08-08" />
+ <row values="1608, 16, init_replica, 160801, 1608, 16, init_replica, 2017-08-08" />
+ <row values="1609, 16, init_replica, 160900, 1609, 16, init_replica, 2017-08-08" />
+ <row values="1609, 16, init_replica, 160901, 1609, 16, init_replica, 2017-08-08" />
+ <row values="1700, 17, init_replica, 170000, 1700, 17, init_replica, 2017-08-08" />
+ <row values="1700, 17, init_replica, 170001, 1700, 17, init_replica, 2017-08-08" />
+ <row values="1701, 17, init_replica, 170100, 1701, 17, init_replica, 2017-08-08" />
+ <row values="1701, 17, init_replica, 170101, 1701, 17, init_replica, 2017-08-08" />
+ <row values="1702, 17, init_replica, 170200, 1702, 17, init_replica, 2017-08-08" />
+ <row values="1702, 17, init_replica, 170201, 1702, 17, init_replica, 2017-08-08" />
+ <row values="1703, 17, init_replica, 170300, 1703, 17, init_replica, 2017-08-08" />
+ <row values="1703, 17, init_replica, 170301, 1703, 17, init_replica, 2017-08-08" />
+ <row values="1704, 17, init_replica, 170400, 1704, 17, init_replica, 2017-08-08" />
+ <row values="1704, 17, init_replica, 170401, 1704, 17, init_replica, 2017-08-08" />
+ <row values="1705, 17, init_replica, 170500, 1705, 17, init_replica, 2017-08-08" />
+ <row values="1705, 17, init_replica, 170501, 1705, 17, init_replica, 2017-08-08" />
+ <row values="1706, 17, init_replica, 170600, 1706, 17, init_replica, 2017-08-08" />
+ <row values="1706, 17, init_replica, 170601, 1706, 17, init_replica, 2017-08-08" />
+ <row values="1707, 17, init_replica, 170700, 1707, 17, init_replica, 2017-08-08" />
+ <row values="1707, 17, init_replica, 170701, 1707, 17, init_replica, 2017-08-08" />
+ <row values="1708, 17, init_replica, 170800, 1708, 17, init_replica, 2017-08-08" />
+ <row values="1708, 17, init_replica, 170801, 1708, 17, init_replica, 2017-08-08" />
+ <row values="1709, 17, init_replica, 170900, 1709, 17, init_replica, 2017-08-08" />
+ <row values="1709, 17, init_replica, 170901, 1709, 17, init_replica, 2017-08-08" />
+ <row values="1800, 18, init_replica, 180000, 1800, 18, init_replica, 2017-08-08" />
+ <row values="1800, 18, init_replica, 180001, 1800, 18, init_replica, 2017-08-08" />
+ <row values="1801, 18, init_replica, 180100, 1801, 18, init_replica, 2017-08-08" />
+ <row values="1801, 18, init_replica, 180101, 1801, 18, init_replica, 2017-08-08" />
+ <row values="1802, 18, init_replica, 180200, 1802, 18, init_replica, 2017-08-08" />
+ <row values="1802, 18, init_replica, 180201, 1802, 18, init_replica, 2017-08-08" />
+ <row values="1803, 18, init_replica, 180300, 1803, 18, init_replica, 2017-08-08" />
+ <row values="1803, 18, init_replica, 180301, 1803, 18, init_replica, 2017-08-08" />
+ <row values="1804, 18, init_replica, 180400, 1804, 18, init_replica, 2017-08-08" />
+ <row values="1804, 18, init_replica, 180401, 1804, 18, init_replica, 2017-08-08" />
+ <row values="1805, 18, init_replica, 180500, 1805, 18, init_replica, 2017-08-08" />
+ <row values="1805, 18, init_replica, 180501, 1805, 18, init_replica, 2017-08-08" />
+ <row values="1806, 18, init_replica, 180600, 1806, 18, init_replica, 2017-08-08" />
+ <row values="1806, 18, init_replica, 180601, 1806, 18, init_replica, 2017-08-08" />
+ <row values="1807, 18, init_replica, 180700, 1807, 18, init_replica, 2017-08-08" />
+ <row values="1807, 18, init_replica, 180701, 1807, 18, init_replica, 2017-08-08" />
+ <row values="1808, 18, init_replica, 180800, 1808, 18, init_replica, 2017-08-08" />
+ <row values="1808, 18, init_replica, 180801, 1808, 18, init_replica, 2017-08-08" />
+ <row values="1809, 18, init_replica, 180900, 1809, 18, init_replica, 2017-08-08" />
+ <row values="1809, 18, init_replica, 180901, 1809, 18, init_replica, 2017-08-08" />
+ <row values="1900, 19, init_replica, 190000, 1900, 19, init_replica, 2017-08-08" />
+ <row values="1900, 19, init_replica, 190001, 1900, 19, init_replica, 2017-08-08" />
+ <row values="1901, 19, init_replica, 190100, 1901, 19, init_replica, 2017-08-08" />
+ <row values="1901, 19, init_replica, 190101, 1901, 19, init_replica, 2017-08-08" />
+ <row values="1902, 19, init_replica, 190200, 1902, 19, init_replica, 2017-08-08" />
+ <row values="1902, 19, init_replica, 190201, 1902, 19, init_replica, 2017-08-08" />
+ <row values="1903, 19, init_replica, 190300, 1903, 19, init_replica, 2017-08-08" />
+ <row values="1903, 19, init_replica, 190301, 1903, 19, init_replica, 2017-08-08" />
+ <row values="1904, 19, init_replica, 190400, 1904, 19, init_replica, 2017-08-08" />
+ <row values="1904, 19, init_replica, 190401, 1904, 19, init_replica, 2017-08-08" />
+ <row values="1905, 19, init_replica, 190500, 1905, 19, init_replica, 2017-08-08" />
+ <row values="1905, 19, init_replica, 190501, 1905, 19, init_replica, 2017-08-08" />
+ <row values="1906, 19, init_replica, 190600, 1906, 19, init_replica, 2017-08-08" />
+ <row values="1906, 19, init_replica, 190601, 1906, 19, init_replica, 2017-08-08" />
+ <row values="1907, 19, init_replica, 190700, 1907, 19, init_replica, 2017-08-08" />
+ <row values="1907, 19, init_replica, 190701, 1907, 19, init_replica, 2017-08-08" />
+ <row values="1908, 19, init_replica, 190800, 1908, 19, init_replica, 2017-08-08" />
+ <row values="1908, 19, init_replica, 190801, 1908, 19, init_replica, 2017-08-08" />
+ <row values="1909, 19, init_replica, 190900, 1909, 19, init_replica, 2017-08-08" />
+ <row values="1909, 19, init_replica, 190901, 1909, 19, init_replica, 2017-08-08" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/replica_query/select_for_left_join.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/replica_query/select_for_left_join.xml
new file mode 100644
index 0000000..98f02c5
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/replica_query/select_for_left_join.xml
@@ -0,0 +1,109 @@
+<!--
+ ~ 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="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="item_id" />
+ <column name="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="creation_date" />
+ </metadata>
+ <row values="1000, 10, init_replica, 100001, 1000, 10, init_replica, 2017-08-08" />
+ <row values="1000, 10, init_replica, 100002, 1000, 10, init_replica, 2017-08-08" />
+ <row values="1001, 10, init_replica, 100101, 1001, 10, init_replica, 2017-08-08" />
+ <row values="1001, 10, init_replica, 100102, 1001, 10, init_replica, 2017-08-08" />
+ <row values="1100, 11, init_replica, 110001, 1100, 11, init_replica, 2017-08-08" />
+ <row values="1100, 11, init_replica, 110002, 1100, 11, init_replica, 2017-08-08" />
+ <row values="1101, 11, init_replica, 110101, 1101, 11, init_replica, 2017-08-08" />
+ <row values="1101, 11, init_replica, 110102, 1101, 11, init_replica, 2017-08-08" />
+ <row values="1200, 12, init_replica, 120001, 1200, 12, init_replica, 2017-08-08" />
+ <row values="1200, 12, init_replica, 120002, 1200, 12, init_replica, 2017-08-08" />
+ <row values="1201, 12, init_replica, 120101, 1201, 12, init_replica, 2017-08-08" />
+ <row values="1201, 12, init_replica, 120102, 1201, 12, init_replica, 2017-08-08" />
+ <row values="1300, 13, init_replica, 130001, 1300, 13, init_replica, 2017-08-08" />
+ <row values="1300, 13, init_replica, 130002, 1300, 13, init_replica, 2017-08-08" />
+ <row values="1301, 13, init_replica, 130101, 1301, 13, init_replica, 2017-08-08" />
+ <row values="1301, 13, init_replica, 130102, 1301, 13, init_replica, 2017-08-08" />
+ <row values="1400, 14, init_replica, 140001, 1400, 14, init_replica, 2017-08-08" />
+ <row values="1400, 14, init_replica, 140002, 1400, 14, init_replica, 2017-08-08" />
+ <row values="1401, 14, init_replica, 140101, 1401, 14, init_replica, 2017-08-08" />
+ <row values="1401, 14, init_replica, 140102, 1401, 14, init_replica, 2017-08-08" />
+ <row values="1500, 15, init_replica, 150001, 1500, 15, init_replica, 2017-08-08" />
+ <row values="1500, 15, init_replica, 150002, 1500, 15, init_replica, 2017-08-08" />
+ <row values="1501, 15, init_replica, 150101, 1501, 15, init_replica, 2017-08-08" />
+ <row values="1501, 15, init_replica, 150102, 1501, 15, init_replica, 2017-08-08" />
+ <row values="1600, 16, init_replica, 160001, 1600, 16, init_replica, 2017-08-08" />
+ <row values="1600, 16, init_replica, 160002, 1600, 16, init_replica, 2017-08-08" />
+ <row values="1601, 16, init_replica, 160101, 1601, 16, init_replica, 2017-08-08" />
+ <row values="1601, 16, init_replica, 160102, 1601, 16, init_replica, 2017-08-08" />
+ <row values="1700, 17, init_replica, 170001, 1700, 17, init_replica, 2017-08-08" />
+ <row values="1700, 17, init_replica, 170002, 1700, 17, init_replica, 2017-08-08" />
+ <row values="1701, 17, init_replica, 170101, 1701, 17, init_replica, 2017-08-08" />
+ <row values="1701, 17, init_replica, 170102, 1701, 17, init_replica, 2017-08-08" />
+ <row values="1800, 18, init_replica, 180001, 1800, 18, init_replica, 2017-08-08" />
+ <row values="1800, 18, init_replica, 180002, 1800, 18, init_replica, 2017-08-08" />
+ <row values="1801, 18, init_replica, 180101, 1801, 18, init_replica, 2017-08-08" />
+ <row values="1801, 18, init_replica, 180102, 1801, 18, init_replica, 2017-08-08" />
+ <row values="1900, 19, init_replica, 190001, 1900, 19, init_replica, 2017-08-08" />
+ <row values="1900, 19, init_replica, 190002, 1900, 19, init_replica, 2017-08-08" />
+ <row values="1901, 19, init_replica, 190101, 1901, 19, init_replica, 2017-08-08" />
+ <row values="1901, 19, init_replica, 190102, 1901, 19, init_replica, 2017-08-08" />
+ <row values="2000, 20, init_replica, 200001, 2000, 20, init_replica, 2017-08-08" />
+ <row values="2000, 20, init_replica, 200002, 2000, 20, init_replica, 2017-08-08" />
+ <row values="2001, 20, init_replica, 200101, 2001, 20, init_replica, 2017-08-08" />
+ <row values="2001, 20, init_replica, 200102, 2001, 20, init_replica, 2017-08-08" />
+ <row values="2100, 21, init_replica, 210001, 2100, 21, init_replica, 2017-08-08" />
+ <row values="2100, 21, init_replica, 210002, 2100, 21, init_replica, 2017-08-08" />
+ <row values="2101, 21, init_replica, 210101, 2101, 21, init_replica, 2017-08-08" />
+ <row values="2101, 21, init_replica, 210102, 2101, 21, init_replica, 2017-08-08" />
+ <row values="2200, 22, init_replica, 220001, 2200, 22, init_replica, 2017-08-08" />
+ <row values="2200, 22, init_replica, 220002, 2200, 22, init_replica, 2017-08-08" />
+ <row values="2201, 22, init_replica, 220101, 2201, 22, init_replica, 2017-08-08" />
+ <row values="2201, 22, init_replica, 220102, 2201, 22, init_replica, 2017-08-08" />
+ <row values="2300, 23, init_replica, 230001, 2300, 23, init_replica, 2017-08-08" />
+ <row values="2300, 23, init_replica, 230002, 2300, 23, init_replica, 2017-08-08" />
+ <row values="2301, 23, init_replica, 230101, 2301, 23, init_replica, 2017-08-08" />
+ <row values="2301, 23, init_replica, 230102, 2301, 23, init_replica, 2017-08-08" />
+ <row values="2400, 24, init_replica, 240001, 2400, 24, init_replica, 2017-08-08" />
+ <row values="2400, 24, init_replica, 240002, 2400, 24, init_replica, 2017-08-08" />
+ <row values="2401, 24, init_replica, 240101, 2401, 24, init_replica, 2017-08-08" />
+ <row values="2401, 24, init_replica, 240102, 2401, 24, init_replica, 2017-08-08" />
+ <row values="2500, 25, init_replica, 250001, 2500, 25, init_replica, 2017-08-08" />
+ <row values="2500, 25, init_replica, 250002, 2500, 25, init_replica, 2017-08-08" />
+ <row values="2501, 25, init_replica, 250101, 2501, 25, init_replica, 2017-08-08" />
+ <row values="2501, 25, init_replica, 250102, 2501, 25, init_replica, 2017-08-08" />
+ <row values="2600, 26, init_replica, 260001, 2600, 26, init_replica, 2017-08-08" />
+ <row values="2600, 26, init_replica, 260002, 2600, 26, init_replica, 2017-08-08" />
+ <row values="2601, 26, init_replica, 260101, 2601, 26, init_replica, 2017-08-08" />
+ <row values="2601, 26, init_replica, 260102, 2601, 26, init_replica, 2017-08-08" />
+ <row values="2700, 27, init_replica, 270001, 2700, 27, init_replica, 2017-08-08" />
+ <row values="2700, 27, init_replica, 270002, 2700, 27, init_replica, 2017-08-08" />
+ <row values="2701, 27, init_replica, 270101, 2701, 27, init_replica, 2017-08-08" />
+ <row values="2701, 27, init_replica, 270102, 2701, 27, init_replica, 2017-08-08" />
+ <row values="2800, 28, init_replica, 280001, 2800, 28, init_replica, 2017-08-08" />
+ <row values="2800, 28, init_replica, 280002, 2800, 28, init_replica, 2017-08-08" />
+ <row values="2801, 28, init_replica, 280101, 2801, 28, init_replica, 2017-08-08" />
+ <row values="2801, 28, init_replica, 280102, 2801, 28, init_replica, 2017-08-08" />
+ <row values="2900, 29, init_replica, 290001, 2900, 29, init_replica, 2017-08-08" />
+ <row values="2900, 29, init_replica, 290002, 2900, 29, init_replica, 2017-08-08" />
+ <row values="2901, 29, init_replica, 290101, 2901, 29, init_replica, 2017-08-08" />
+ <row values="2901, 29, init_replica, 290102, 2901, 29, init_replica, 2017-08-08" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/tbl/select_for_left_join.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/tbl/select_for_left_join.xml
new file mode 100644
index 0000000..af3103d
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dataset/tbl/select_for_left_join.xml
@@ -0,0 +1,69 @@
+<!--
+ ~ 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="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="item_id" />
+ <column name="order_id" />
+ <column name="user_id" />
+ <column name="status" />
+ <column name="creation_date" />
+ </metadata>
+ <row values="1000, 10, init, 100000, 1000, 10, init, 2017-08-08" />
+ <row values="1000, 10, init, 100001, 1000, 10, init, 2017-08-08" />
+ <row values="1100, 11, init, 110000, 1100, 11, init, 2017-08-18" />
+ <row values="1100, 11, init, 110001, 1100, 11, init, 2017-08-18" />
+ <row values="1001, 10, init, 100100, 1001, 10, init, 2017-08-08" />
+ <row values="1001, 10, init, 100101, 1001, 10, init, 2017-08-08" />
+ <row values="1101, 11, init, 110100, 1101, 11, init, 2017-08-18" />
+ <row values="1101, 11, init, 110101, 1101, 11, init, 2017-08-18" />
+ <row values="1002, 10, init, 100200, 1002, 10, init, 2017-08-08" />
+ <row values="1002, 10, init, 100201, 1002, 10, init, 2017-08-08" />
+ <row values="1102, 11, init, 110200, 1102, 11, init, 2017-08-18" />
+ <row values="1102, 11, init, 110201, 1102, 11, init, 2017-08-18" />
+ <row values="1003, 10, init, 100300, 1003, 10, init, 2017-08-08" />
+ <row values="1003, 10, init, 100301, 1003, 10, init, 2017-08-08" />
+ <row values="1103, 11, init, 110300, 1103, 11, init, 2017-08-18" />
+ <row values="1103, 11, init, 110301, 1103, 11, init, 2017-08-18" />
+ <row values="1004, 10, init, 100400, 1004, 10, init, 2017-08-08" />
+ <row values="1004, 10, init, 100401, 1004, 10, init, 2017-08-08" />
+ <row values="1104, 11, init, 110400, 1104, 11, init, 2017-08-18" />
+ <row values="1104, 11, init, 110401, 1104, 11, init, 2017-08-18" />
+ <row values="1005, 10, init, 100500, 1005, 10, init, 2017-08-09" />
+ <row values="1005, 10, init, 100501, 1005, 10, init, 2017-08-09" />
+ <row values="1105, 11, init, 110500, 1105, 11, init, 2017-08-19" />
+ <row values="1105, 11, init, 110501, 1105, 11, init, 2017-08-19" />
+ <row values="1006, 10, init, 100600, 1006, 10, init, 2017-08-09" />
+ <row values="1006, 10, init, 100601, 1006, 10, init, 2017-08-09" />
+ <row values="1106, 11, init, 110600, 1106, 11, init, 2017-08-19" />
+ <row values="1106, 11, init, 110601, 1106, 11, init, 2017-08-19" />
+ <row values="1007, 10, init, 100700, 1007, 10, init, 2017-08-09" />
+ <row values="1007, 10, init, 100701, 1007, 10, init, 2017-08-09" />
+ <row values="1107, 11, init, 110700, 1107, 11, init, 2017-08-19" />
+ <row values="1107, 11, init, 110701, 1107, 11, init, 2017-08-19" />
+ <row values="1008, 10, init, 100800, 1008, 10, init, 2017-08-09" />
+ <row values="1008, 10, init, 100801, 1008, 10, init, 2017-08-09" />
+ <row values="1108, 11, init, 110800, 1108, 11, init, 2017-08-19" />
+ <row values="1108, 11, init, 110801, 1108, 11, init, 2017-08-19" />
+ <row values="1009, 10, init, 100900, 1009, 10, init, 2017-08-09" />
+ <row values="1009, 10, init, 100901, 1009, 10, init, 2017-08-09" />
+ <row values="1109, 11, init, 110900, 1109, 11, init, 2017-08-19" />
+ <row values="1109, 11, init, 110901, 1109, 11, init, 2017-08-19" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
index 14afaab..3838445 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
@@ -477,4 +477,8 @@
from t_order t left join t_order_item as o on o.order_id =t.order_id where t.order_id=1000 limit 1" db-types="MySQL,H2">
<assertion expected-data-file="select_with_case_expression.xml" />
</test-case>
+
+ <test-case sql="SELECT * FROM t_order o LEFT JOIN t_order_item m ON o.order_id = m.order_id" db-types="MySQL,H2">
+ <assertion expected-data-file="select_for_left_join.xml"/>
+ </test-case>
</integration-test-cases>