This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 6758dfe96fb [fix](nereids)InSubquery's withChildren method lost
typeCoercionExpr (#33694)
6758dfe96fb is described below
commit 6758dfe96fb46bd921b2040d0cb727d6151fb117
Author: starocean999 <[email protected]>
AuthorDate: Tue Apr 16 14:14:52 2024 +0800
[fix](nereids)InSubquery's withChildren method lost typeCoercionExpr
(#33694)
pick from master #33692
---
.../java/org/apache/doris/nereids/trees/expressions/InSubquery.java | 2 +-
regression-test/suites/nereids_p0/subquery/test_subquery.groovy | 1 +
2 files changed, 2 insertions(+), 1 deletion(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/InSubquery.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/InSubquery.java
index b04f9d3d78b..8b7d0518181 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/InSubquery.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/InSubquery.java
@@ -106,7 +106,7 @@ public class InSubquery extends SubqueryExpr {
public InSubquery withChildren(List<Expression> children) {
Preconditions.checkArgument(children.size() == 2);
Preconditions.checkArgument(children.get(1) instanceof ListQuery);
- return new InSubquery(children.get(0), (ListQuery) children.get(1),
isNot);
+ return new InSubquery(children.get(0), (ListQuery) children.get(1),
correlateSlots, typeCoercionExpr, isNot);
}
@Override
diff --git a/regression-test/suites/nereids_p0/subquery/test_subquery.groovy
b/regression-test/suites/nereids_p0/subquery/test_subquery.groovy
index 21dd257a274..51ae10c060a 100644
--- a/regression-test/suites/nereids_p0/subquery/test_subquery.groovy
+++ b/regression-test/suites/nereids_p0/subquery/test_subquery.groovy
@@ -268,6 +268,7 @@ suite("test_subquery") {
qt_select60 """select * from t1 where exists(select distinct k1 from
t2 where t1.k1 > t2.k3 or t1.k2 < t2.v1) order by t1.k1, t1.k2;"""
qt_select61 """SELECT * FROM t1 AS t1 WHERE EXISTS (SELECT k1 FROM t1 AS
t2 WHERE t1.k1 <> t2.k1 + 7 GROUP BY k1 HAVING k1 >= 100);"""
qt_select62 """select * from t1 left semi join ( select * from t1 where
t1.k1 < -1 ) l on true;"""
+ sql """SELECT count(1) as c FROM t1 HAVING c IN (select k1 from t2);"""
sql "drop table if exists t1"
sql "drop table if exists t2"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
