This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new 05bae644d8e branch-4.0: [fix](case) fix regression test
add_project_for_unique_function (#59682)
05bae644d8e is described below
commit 05bae644d8e6fd94be84f9250a09f5a997d1bcf2
Author: yujun <[email protected]>
AuthorDate: Mon Jan 12 09:57:47 2026 +0800
branch-4.0: [fix](case) fix regression test add_project_for_unique_function
(#59682)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR
should merge into -->
---
.../unique_function/add_project_for_unique_function.out | 9 ++++-----
1 file changed, 4 insertions(+), 5 deletions(-)
diff --git
a/regression-test/data/nereids_rules_p0/unique_function/add_project_for_unique_function.out
b/regression-test/data/nereids_rules_p0/unique_function/add_project_for_unique_function.out
index 36daa0d825d..a0ae11e5792 100644
---
a/regression-test/data/nereids_rules_p0/unique_function/add_project_for_unique_function.out
+++
b/regression-test/data/nereids_rules_p0/unique_function/add_project_for_unique_function.out
@@ -121,14 +121,13 @@ PhysicalResultSink
-- !agg_1 --
PhysicalResultSink
--hashAgg[GLOBAL, groupByExpr=(), outputExpr=(sum(cast(AND[($_random_5_$ >=
0.6),($_random_5_$ <= 0.7)] as TINYINT)) AS `sum(random(100) between 0.6 and
0.7)`)]
-----PhysicalProject[$_random_5_$, cast(AND[($_random_5_$ >= 0.6),($_random_5_$
<= 0.7)] as TINYINT) AS `cast(AND[($_random_5_$ >= 0.6),($_random_5_$ <= 0.7)]
as TINYINT)`]
-------PhysicalOneRowRelation[random(100) AS `$_random_5_$`]
+----PhysicalOneRowRelation[random(100) AS `$_random_5_$`]
-- !agg_2 --
PhysicalResultSink
--hashAgg[GLOBAL, groupByExpr=(), outputExpr=(sum(cast(AND[($_random_5_$ >=
0.6),($_random_5_$ <= 0.7)] as TINYINT)) AS `sum(random(100) between 0.6 and
0.7)`, sum(id) AS `sum(id)`)]
----hashAgg[LOCAL, groupByExpr=(),
outputExpr=(partial_sum(cast(AND[($_random_5_$ >= 0.6),($_random_5_$ <= 0.7)]
as TINYINT)) AS `partial_sum(cast(AND[($_random_5_$ >= 0.6),($_random_5_$ <=
0.7)] as TINYINT))`, partial_sum(id) AS `partial_sum(id)`)]
-------PhysicalProject[cast(AND[(random(100) >= 0.6),(random(100) <= 0.7)] as
TINYINT) AS `cast(AND[($_random_5_$ >= 0.6),($_random_5_$ <= 0.7)] as
TINYINT)`, random(100) AS `$_random_5_$`, t1.id]
+------PhysicalProject[random(100) AS `$_random_5_$`, t1.id]
--------PhysicalOlapScan[t1]
-- !agg_3 --
@@ -136,7 +135,7 @@ PhysicalResultSink
--PhysicalProject[sum(id), sum(random(100) between 0.6 and 0.7)]
----hashAgg[GLOBAL, groupByExpr=(AND[(random() >= cast(0.1 as
DOUBLE)),(random() <= cast(0.5 as DOUBLE))]), outputExpr=(AND[(random() >=
cast(0.1 as DOUBLE)),(random() <= cast(0.5 as DOUBLE))],
sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as TINYINT)) AS
`sum(random(100) between 0.6 and 0.7)`, sum(id) AS `sum(id)`)]
------hashAgg[LOCAL, groupByExpr=(AND[(random() >= cast(0.1 as
DOUBLE)),(random() <= cast(0.5 as DOUBLE))]), outputExpr=(AND[(random() >=
cast(0.1 as DOUBLE)),(random() <= cast(0.5 as DOUBLE))],
partial_sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as TINYINT))
AS `partial_sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as
TINYINT))`, partial_sum(id) AS `partial_sum(id)`)]
---------PhysicalProject[AND[($_random_8_$ >= 0.1),($_random_8_$ <= 0.5)] AS
`AND[(random() >= cast(0.1 as DOUBLE)),(random() <= cast(0.5 as DOUBLE))]`,
cast(AND[(random(100) >= 0.6),(random(100) <= 0.7)] as TINYINT) AS
`cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as TINYINT)`,
random(100) AS `$_random_7_$`, t1.id]
+--------PhysicalProject[AND[($_random_8_$ >= 0.1),($_random_8_$ <= 0.5)] AS
`AND[(random() >= cast(0.1 as DOUBLE)),(random() <= cast(0.5 as DOUBLE))]`,
random(100) AS `$_random_7_$`, t1.id]
----------PhysicalProject[random() AS `$_random_8_$`, t1.id]
------------PhysicalOlapScan[t1]
@@ -145,7 +144,7 @@ PhysicalResultSink
--PhysicalProject[sum(id), sum(random(100) between 0.6 and 0.7)]
----hashAgg[GLOBAL, groupByExpr=(AND[((cast(id as DOUBLE) + random()) >=
cast(0.1 as DOUBLE)),((cast(id as DOUBLE) + random()) <= cast(0.5 as
DOUBLE))]), outputExpr=(AND[((cast(id as DOUBLE) + random()) >= cast(0.1 as
DOUBLE)),((cast(id as DOUBLE) + random()) <= cast(0.5 as DOUBLE))],
sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as TINYINT)) AS
`sum(random(100) between 0.6 and 0.7)`, sum(id) AS `sum(id)`)]
------hashAgg[LOCAL, groupByExpr=(AND[((cast(id as DOUBLE) + random()) >=
cast(0.1 as DOUBLE)),((cast(id as DOUBLE) + random()) <= cast(0.5 as
DOUBLE))]), outputExpr=(AND[((cast(id as DOUBLE) + random()) >= cast(0.1 as
DOUBLE)),((cast(id as DOUBLE) + random()) <= cast(0.5 as DOUBLE))],
partial_sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as TINYINT))
AS `partial_sum(cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as
TINYINT))`, partial_sum(id) AS `partial_sum(id)`)]
---------PhysicalProject[AND[((cast(id as DOUBLE) + $_random_8_$) >=
0.1),((cast(id as DOUBLE) + $_random_8_$) <= 0.5)] AS `AND[((cast(id as DOUBLE)
+ random()) >= cast(0.1 as DOUBLE)),((cast(id as DOUBLE) + random()) <=
cast(0.5 as DOUBLE))]`, cast(AND[(random(100) >= 0.6),(random(100) <= 0.7)] as
TINYINT) AS `cast(AND[($_random_7_$ >= 0.6),($_random_7_$ <= 0.7)] as
TINYINT)`, random(100) AS `$_random_7_$`, t1.id]
+--------PhysicalProject[AND[((cast(id as DOUBLE) + $_random_8_$) >=
0.1),((cast(id as DOUBLE) + $_random_8_$) <= 0.5)] AS `AND[((cast(id as DOUBLE)
+ random()) >= cast(0.1 as DOUBLE)),((cast(id as DOUBLE) + random()) <=
cast(0.5 as DOUBLE))]`, random(100) AS `$_random_7_$`, t1.id]
----------PhysicalProject[random() AS `$_random_8_$`, t1.id]
------------PhysicalOlapScan[t1]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
