This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 29f564002fd08aa870a378df9e605ed6a2250035
Author: morrySnow <101034200+morrys...@users.noreply.github.com>
AuthorDate: Fri Apr 12 12:34:45 2024 +0800
[chore](test) update one join case for nereids because ambiguous name
(#33562)
---
regression-test/suites/query_p0/join/test_join.groovy | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/regression-test/suites/query_p0/join/test_join.groovy
b/regression-test/suites/query_p0/join/test_join.groovy
index 5f25ea52234..b3955d56f27 100644
--- a/regression-test/suites/query_p0/join/test_join.groovy
+++ b/regression-test/suites/query_p0/join/test_join.groovy
@@ -389,10 +389,10 @@ suite("test_join", "query,p0") {
}
sql"""select a.k1 k1, a.k2, a.k3, b.k1, b.k2, b.k3 from ${tbName1} a full
outer join ${tbName2} b
on a.k1 = b.k1 and a.k2 > b.k2 order by isnull(k1), 1, 2, 3, 4, 5
limit 65535"""
- sql"""select a.k1 k1, a.k2, a.k3, b.k1, b.k2, b.k3 from ${tbName1} a left
outer join ${tbName2} b
- on a.k1 = b.k1 and a.k2 > b.k2 union (select a.k1, a.k2, a.k3,
b.k1, b.k2, b.k3
+ sql"""select a.k1 ak1, a.k2 ak2, a.k3 ak3, b.k1 bk1, b.k2 bk2, b.k3 bk3
from ${tbName1} a left outer join ${tbName2} b
+ on a.k1 = b.k1 and a.k2 > b.k2 union (select a.k1 ak1, a.k2 ak2,
a.k3 ak3, b.k1 bk1, b.k2 bk2, b.k3 bk3
from ${tbName1} a right outer join ${tbName2} b on a.k1 = b.k1
and a.k2 > b.k2)
- order by isnull(k1), 1, 2, 3, 4, 5 limit 65535"""
+ order by isnull(ak1), 1, 2, 3, 4, 5 limit 65535"""
sql"""select count(*) from ${tbName1} a full outer join ${tbName2} b on
a.k2 = b.k2 and a.k1 > 0
full outer join ${tbName3} c on a.k3 = c.k3 and b.k1 = c.k1 and
c.k3 > 0"""
sql"""select count(*) from ((select a.k1 as k1, b.k1 as k2, a.k2 as k3,
b.k2 as k4, a.k3 as k5, b.k3 as k6, c.k1 as k7, c.k2 as k8, c.k3 as k9 from
${tbName1} a
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
