This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6d3ae1e69c [regression](left join)Add left join, the left table is
empty, the query result is not empty case (#12344)
6d3ae1e69c is described below
commit 6d3ae1e69c1afd42d89cc9de9a2d9b85b21af8d0
Author: caoliang-web <[email protected]>
AuthorDate: Mon Sep 19 08:53:50 2022 +0800
[regression](left join)Add left join, the left table is empty, the query
result is not empty case (#12344)
Add left join, the left table is empty, the query result is not empty case
---
.../data/query/join/test_left_join_null.out | 4 ++
.../suites/query/join/test_left_join_null.groovy | 63 ++++++++++++++++++++++
2 files changed, 67 insertions(+)
diff --git a/regression-test/data/query/join/test_left_join_null.out
b/regression-test/data/query/join/test_left_join_null.out
new file mode 100644
index 0000000000..ec39c781df
--- /dev/null
+++ b/regression-test/data/query/join/test_left_join_null.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select --
+1001 test \N
+
diff --git a/regression-test/suites/query/join/test_left_join_null.groovy
b/regression-test/suites/query/join/test_left_join_null.groovy
new file mode 100644
index 0000000000..42227b6485
--- /dev/null
+++ b/regression-test/suites/query/join/test_left_join_null.groovy
@@ -0,0 +1,63 @@
+// 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.
+
+suite("test_left_join_null", "query") {
+
+ def tbName1 = "dept_emp"
+ def tbName2 = "departments"
+
+ sql """
+ CREATE TABLE IF NOT EXISTS ${tbName1} (
+ `emp_no` int NOT NULL,
+ `dept_no` char(4) NOT NULL,
+ `from_date` date NOT NULL,
+ `to_date` date NOT NULL
+ )
+ unique KEY (`emp_no`,`dept_no`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`emp_no`) BUCKETS 3
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "in_memory" = "false",
+ "storage_format" = "V2"
+ );
+ """
+
+ sql """
+ CREATE TABLE IF NOT EXISTS ${tbName2} (
+ `dept_no` char(4) NOT NULL,
+ `dept_name` varchar(40) NOT NULL
+ )
+ UNIQUE KEY (`dept_no`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`dept_no`) BUCKETS 3
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "in_memory" = "false",
+ "storage_format" = "V2"
+ );
+ """
+ sql """insert into ${tbName2} values ('1001','test')"""
+
+ qt_select """
+ with test as (
+ SELECT dept_no from dept_emp
+ )
+ SELECT * from departments a LEFT JOIN test b on
a.dept_no=b.dept_no
+ """
+
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
